sqlite date comparison

Question

I have column of type date time and values are getting stored in format 10-29-2011 08:25.

I would like to find out the rows only which are less then current date-time. What will be the condition for date comparison for current date and this date-time column field?

Thanks.

see http://stackoverflow.com/questions/1975737/sqlite-datetime-comparison — ewok, Oct 31 '11 at 17:12

score 0 · Answer 1 · answered Dec 11 '13 at 17:46

0

you could use the datetime function

SELECT * FROM mytable
WHERE mydate > datetime('now')

you can even make date operations

SELECT * FROM mytable
WHERE mydate > datetime('now','-15 days')

answered Dec 11 '13 at 17:46

Flávio Rodrigues

64
4

sqlite date comparison

1 Answers1

Linked