SQLite has no date/time types, only strings and numbers, and functions that can interpret certain strings or numbers as date/times. That design choice actually

SQLite has no date/time types, only strings and numbers, and functions that can interpret certain strings or numbers as date/times. That design choice actually made a lot of sense in the past, because unlike most other databases SQLite didn't have rigid typed columns. Now you could roll your own rigid column types using CHECK constraints, but then you would just use the date/time functions to enforce date/times column values, so there was no need for separate date/time datatypes. But recently they've implementedn STRICT tables with rigid column types, so maybe they'll add date/time datatypes at some point as well.