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

"Alistair Bayley" <alistair(at)abayley(dot)org> writes:
>> 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?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rafal Pietrak 2006-07-29 16:59:49 use of index
Previous Message Flemming Frandsen 2006-07-29 14:46:22 Re: Performance of the listen command