3 ms·
Why not store them as integers? Representing dates is a UI responsibility
by sheept 3mo ago
Why not store them as integers? Representing dates is a UI responsibility
- panzi 3mo agoI also want to be able to debug the database in an SQL console with nice looking date-times.
- thaumasiotes 3mo agoYou can already do that: https://sqlite.org/lang_datefunc.html https://sqlite.org/lang_datefunc.html
- masfuerte 3mo agoJust to state the obvious, you can create a view which uses these functions to make your integer date/times readable, and then debugging is easy.
- nullisland00 3mo agoForcing all dates to be cast to a single time zone (UTC) complicates workflows when you’re on the other side of the globe. Many DBs have added a timestamp offset type for this to keep the data in the offset it occurred in.