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

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Alistair Bayley" <alistair(at)abayley(dot)org>
Cc: <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 11:21:05
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCEA35542@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> >> Magnus, did you have a specific reason for choosing
> Europe/Dublin, or
> >> was it just alphabetically first? Europe/London looks at least
> >> marginally closer to what one would think "GMT" means:
>
> > 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.

//Magnus

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2006-08-18 11:29:34 Re: PostgreSQL and Windows 2003 DFS Replication
Previous Message Magnus Hagander 2006-08-18 11:14:45 Re: Pl/TCL: Is my Windows install missing scripts?