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

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "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:10:42
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E40154C7DA@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
> Sent: 23 August 2006 14:05
> To: Alistair Bayley
> Cc: Magnus Hagander; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] What's special about 1916-10-01
> 02:25:20? Odd jump in internal timestamptz representation
>
> 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?

That particular setting is a DWORD registry key:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\TimeZoneInformation\
DisableAutoDaylightTimeSet

0 (or non-existant) means the box is checked, 1 when it is cleared.

Regards, Dave.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Enver ALTIN 2006-08-23 13:13:24 Re: How do i store arbitrary questions and answers in SQL?
Previous Message Alvaro Herrera 2006-08-23 13:07:35 Re: [8.1.4] Create index on timestamp fails