Click here to Skip to main content
12,070,030 members (30,507 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 .


Regards
karthick
Posted 22-Aug-11 3:50am

1 solution

Rate this: bad
 
good
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!
  Permalink  
Comments
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
Web03 | 2.8.160208.1 | Last Updated 22 Aug 2011
Copyright © CodeProject, 1999-2016
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