SQLite Forum

Getting a date range using "like"
Login
What Keith said, plus the fact that NUMERIC is perfect for a column with date and time values and should work perfectly for your case.

Also, in SQLite there is a [pragma "case_sensitive_like"](https://sqlite.org/pragma.html#pragma_case_sensitive_like) if you fancy changing that behaviour.