I have a SQLite3 table "data" with a column "ts" that of type DATETIME
.
Based on the docs, I tried the following query:
SELECT count(*) FROM mds_daily_data WHERE ts >= '2020-10-07 12:27:00';
This returned no results. However, it did work when I compared against the unix-epoch timestamp equivalent of '2020-10-07 12:27:00', which is 1602073620:
SELECT count(*) FROM mds_daily_data WHERE ts >= 1602073620;
Why does the latter work and the former fail?