SQLite Forum

Getting a date range using "like"
Login
Can't test at the moment, but I seem to remember that `LIKE` uses a `NOCASE` search, and a default index is case sensitive. You might try making the timestamp column, or the index on it, `NOCASE`.