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

[Peter J. Holzer]

On 2021-09-04 21:48:14 +0200, Peter J. Holzer wrote:
> On 2021-09-02 08:32:36 +0100, Alan Gauld via Python-list 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.
> 
> That makes no sense. With DST the clocks are changed in summer, and they
> are set forward, so it's darker at the same time in the morning.
> 
> Maybe you are talking about switching to DST for the whole year or just
> moving to CET? That would have the effect of it being noticably darker
> in the morning in winter.

Found it. Between 1968-02-18 and 1971-10-30 was continuously on
UTC+0100 (probably to be in the same timezone as Germany and France
(which didn't have DST at that time).

        hp

-- 
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp at hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <https://mail.python.org/pipermail/python-list/attachments/20210904/b54616db/attachment.sig>