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

[Chris Angelico]

On Fri, Sep 3, 2021 at 4:26 AM Alan Gauld via Python-list
<python-list at python.org> wrote:
>
> On 31/08/2021 22:32, Chris Angelico wrote:
>
> > If we could abolish DST world-wide, life would be far easier. All the
> > rest of it would be easy enough to handle.
> We tried that in the UK for 2 years back in the '70s and very
> quickly reverted to DST when they realized that the number
> of fatalities among young children going to school doubled
> during those two years.
>
> Without DST the schools opened in the dark so all the kids
> had to travel to school in the dark and the number of
> traffic accidents while crossing roads jumped.

How do they manage in winter? Can that be solved with better street
lighting? That was fifty years ago now, and the negative consequences
of DST are far stronger now.

ChrisA