The sqlite3 timestamp conversion between unixepoch and localtime
Barry
barry at barrys-emacs.org
Fri Sep 3 17:53:34 EDT 2021
> 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
>
More information about the Python-list
mailing list