The sqlite3 timestamp conversion between unixepoch and localtime

[Barry]

> On 3 Sep 2021, at 13:40, Bob Martin <bob.martin at excite.com> wrote:
> 
> On 2 Sep 2021 at 20:25:27, Alan Gauld <alan.gauld at yahoo.co.uk> wrote:
>> On 02/09/2021 20:11, MRAB wrote:
>> 
>>>> In one of them (I can't recall which is which) they change on the 4th
>>>> weekend of October/March in the other they change on the last weekend.
>>>> 
>>>> 
>>> In the EU (and UK) it's the last Sunday in March/October.
>>> 
>>> In the US it's second Sunday in March and the first Sunday in November.
>>> 
>>> I know which one I find easier to remember!
>> 
>> Interesting. I remember it as closer than that. The bugs we found were
>> due to differences in the DST settings of the BIOS in the PCs. (They
>> were deliberately all sourced from DELL but the EU PCs had a slightly
>> different BIOS).
>> 
>> The differences you cite should have thrown up issues every year.
>> I must see if I can find my old log books...
>> 
> 
> ISTR that the USA changes were the same as the EU until a few years ago.

I recall that DST changes have been at least 1 week different between the UK and USA since the 80’s.

Barry
> 
> I remember thinking at the time it changed "why would they do that?"
> 
> -- 
> https://mail.python.org/mailman/listinfo/python-list
>