SQLite Forum

select between two dates
Login
'now' is a string because it is in single quotes. Also, your numeric literals are actually strings. Luckily SQLite will apply affinity before comparing.

You need to use the strftime() function to convert between time strings and "seconds since 1970-01-01".