This and DATETIME. The workarounds for these are mostly fine if you’re just using SQLite as a key value store, but doing translations in SQL queries for these workarounds sounds atrocious.
If you find yourself caring about data types or actually writing a query, you should probably setup an actual database server.