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: "Magnus Hagander" <mha(at)sollentuna(dot)net>, 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-23 13:05:19
Message-ID: 18223.1156338319@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:
> On 18/08/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> I guess the question is whether, when Windows is using this setting,
>> it tracks British summer time rules or not. Would someone check?

> What would a reasonable check be? I can start the Windows command
> prompt and type "time /t" which gives me the current local time
> (adjusted for daylight savings). In the Windows Date/Time dialogue
> there is a "Automatically adjust clock for daylight saving changes"
> checkbox, which is checked. I don't know what registry setting this
> maps to, though.

Hm. It kinda sounds like you might get true GMT if that box is not
checked, and the equivalent of Europe/London if it is checked.

I have a vague recollection that we discussed this before and determined
that there's no direct way for a program to find out if that box is
checked though?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roman Neuhauser 2006-08-23 13:05:35 Re: UUID as primary key
Previous Message Alistair Bayley 2006-08-23 12:52:35 Re: What's special about 1916-10-01 02:25:20? Odd jump in internal timestamptz representation