SQLite supports computed columns, so you could just add a virtual text column next to the 'real' epoch column defined as the date representation of your choice.

SQLite supports computed columns, so you could just add a virtual text column next to the 'real' epoch column defined as the date representation of your choice. https://www.sqlite.org/draft/gencol.html https://www.sqlite.org/draft/gencol.html Ignore the text column in your application so it won't be computed at runtime, but it will appear when you 'select *' or use a db browser in exploration mode.