The sqlite3 timestamp conversion between unixepoch and localtime can't be done according to the timezone setting on the machine automatically.

[Michael F. Stemper]

On 31/08/2021 16.13, Chris Angelico wrote:

> 
> But ultimately, it all just means that timezones are too hard for
> humans to handle, and we MUST handle them using IANA's database. It is
> the only way.

Tom Scott makes this point quite strongly on Computerphile:

<https://www.youtube.com/watch?v=-5wpm-gesOY>

And amusingly.

-- 
Michael F. Stemper
Always remember that you are unique. Just like everyone else.