Click here to Skip to main content
11,922,641 members (56,711 online)
Rate this:
Please Sign up or sign in to vote.
See more: SQLite
Hi ,

I am using Sqlite i have coloumn's "from date" and "to date".

i need get the from to date .
from date --|-- To date
ex: 02-03-2011 to 15-04-2011

i need to get in between data's value .

Posted 22-Aug-11 3:50am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Try the BETWEEN statement:
SELECT * FROM myTable WHERE myDate BETWEEN fromDate AND toDate
Remember it is inclusive!
karthickjce 22-Aug-11 23:30pm
Hi I already try this query. No Value Displaying. If i give from date and to date same month it will working . I need two moths of data feb to march .
OriginalGriff 23-Aug-11 3:20am
IF your data type is date, it should work - show the code fragment you are using.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.151125.1 | Last Updated 22 Aug 2011
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100