how to compare datetime in SQLite

Question

I have stored entrytime in "2012-09-12_12:45" format in SQLite table, now I have to find all entries between 08:00 to 19:00. Please suggest me query to find such kind of entries.

duplicate: http://stackoverflow.com/questions/1975737/sqlite-datetime-comparison — Stew, Dec 05 '12 at 13:36

score 0 · Answer 1 · answered Dec 05 '12 at 15:42

0

SELECT * FROM MyTable WHERE substr(MyColumn, 12, 5) BETWEEN '08:00' AND '19:00'

answered Dec 05 '12 at 15:42

CL.

173,858
17
217
259

how to compare datetime in SQLite

1 Answers1