5 ms·
Of course you can store timestamps as integers, but then you lose sqlite's built-in date and time functions.
by mort96 3mo ago
Of course you can store timestamps as integers, but then you lose sqlite's built-in date and time functions.
- masklinn 3mo agoYou 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 https://sqlite.org/lang_datefunc.html for the details.