Re: What's special about 1916-10-01 02:25:20? Odd jump in internal timestamptz representation - Mailing list pgsql-general

From Tom Lane
Subject Re: What's special about 1916-10-01 02:25:20? Odd jump in internal timestamptz representation
Date
Msg-id 7479.1155906689@sss.pgh.pa.us
Whole thread Raw
In response to Re: What's special about 1916-10-01 02:25:20? Odd jump in internal timestamptz representation  ("Magnus Hagander" <mha@sollentuna.net>)
Responses Re: What's special about 1916-10-01 02:25:20? Odd jump in internal timestamptz representation  ("Alistair Bayley" <alistair@abayley.org>)
List pgsql-general
"Magnus Hagander" <mha@sollentuna.net> writes:
>>> Does it have to be a specific city? I'd rather it just chose GMT.
>>
>> The fact that there is an entry for "GMT Daylight Time" means that
>> Windows' idea of this time zone is not pure GMT.  Or is the
>> translation table entry a complete work of fiction?

> No, it's a work of a simplistic perlscript IIRC. It simply looked for
> the first match it could find, based on the list found in the registry
> (the whole concept is a bit of an ugly hack, but it's the best we could
> come up with). If there is a more fitting timezone for it, it should be
> changed.

I guess the question is whether, when Windows is using this setting,
it tracks British summer time rules or not.  Would someone check?

            regards, tom lane

pgsql-general by date:

Previous
From: Roman Neuhauser
Date:
Subject: Re: select * from users where user_id NOT in (select
Next
From: Michael Meskes
Date:
Subject: Re: Connection string