Unix Timestamp Or Is0-8601 Date String In Sqlite

SQLite doesn't support DATE/DATETIME data type. Therefore datetime can be presented in database as unix timestamp e.g. integer, number of seconds since Jan 01 1970 or as IS0-8601 s

Solution 1:

Unix timestamps overflow in the year 2038 only if they are stored as 32-bit values. SQLite supports 64-bit values.

A single number requires less storage space than a string (but this matters only if you have a very large number of records). You have to balance this against the easier debuggability of strings.