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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: "Alistair Bayley" <alistair(at)abayley(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: What's special about 1916-10-01 02:25:20? Odd jump in internal timestamptz representation
Date: 2006-08-18 13:11:29
Message-ID: 7479.1155906689@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Magnus Hagander" <mha(at)sollentuna(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roman Neuhauser 2006-08-18 14:20:33 Re: select * from users where user_id NOT in (select
Previous Message Magnus Hagander 2006-08-18 11:29:34 Re: PostgreSQL and Windows 2003 DFS Replication