[mort96]

Of course you can store timestamps as integers, but then you lose sqlite's built-in date and time functions.

[masklinn]

You do not. SQLite date/time functions work with time-values which can be ISO timestamp strings, Julian fractional day numbers, or Unix timestamps. See https://sqlite.org/lang_datefunc.html for the details.