In my sqlite database there is a "Date" field, & its data type is varchar,
I want to get all data between two dates - how would I do this from a sqlite database?
Asked
Active
Viewed 5,194 times
1
-
http://stackoverflow.com/a/1976040/919545 – Ankit Srivastava Mar 01 '12 at 10:24
-
show me any record of dates. which date formate you use in record? – Mar 01 '12 at 10:41
-
possible duplicate of [SQLite DateTime comparison](http://stackoverflow.com/questions/1975737/sqlite-datetime-comparison) – mmmmmm Mar 01 '12 at 12:06
3 Answers
2
Try this
NSString * sql = [[NSString alloc] initWithFormat:@"SELECT * FROM table WHERE (startdate <='%@') AND (enddate >='%@)",startdateString, enddateString];
OR
SELECT * FROM table WHERE datecol BETWEEN '2012-02-08 00:00:00' AND '2012-01-10 00:00:00'
Hector
- 3,909
- 2
- 30
- 46
0
- date(timestring, modifier, modifier, ...)
- time(timestring, modifier, modifier, ...)
- datetime(timestring, modifier, modifier, ...)
- julianday(timestring, modifier, modifier, ...)
- strftime(format, timestring, modifier, modifier, ...)
Use one of the above function to convert your string to date More detail please refer: http://www.sqlite.org/lang_datefunc.html
Hanon
- 3,917
- 2
- 25
- 29
-
And after converting it to date, try this: SELECT data FROM myTable WHERE date BETWEEN date1 AND date2 – Antonio MG Mar 01 '12 at 10:28
0
The best solution is here: Working with strings in SQLite.
trashgod
- 203,806
- 29
- 246
- 1,045
Riddhish.Chaudhari
- 833
- 1
- 8
- 24