[thaumasiotes]

You can already do that: https://sqlite.org/lang_datefunc.html

[masfuerte]

Just 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.