Re: Time bug with small years - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Time bug with small years
Date
Msg-id 24689.1322154054@sss.pgh.pa.us
Whole thread Raw
In response to Re: Time bug with small years  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Nov 23, 2011 at 11:45 PM, Rod Taylor <pg@rbt.ca> wrote:
>> sk_test=# select '1894-01-01'::timestamp with time zone;
>>          timestamptz
>> ------------------------------
>>  1894-01-01 00:00:00-05:17:32
>> (1 row)

> On my system, all current time zone offsets are multiples of 15
> minutes, but historically that wasn't the case.  It seems that in your
> local time zone, the offset versus UTC was, as of January 1, 1894,
> minus five hours, seventeen minutes, and 32 seconds.

And in fact, a quick grep through the timezone database shows that
you must be using America/Toronto:

# Zone    NAME        GMTOFF    RULES    FORMAT    [UNTIL]
Zone America/Toronto    -5:17:32 -    LMT    1895        -5:00    Canada    E%sT    1919        -5:00    Toronto
E%sT   1942 Feb  9 2:00s        -5:00    Canada    E%sT    1946        -5:00    Toronto    E%sT    1974        -5:00
Canada   E%sT
 

The general practice in the Olson database is to show localities as
using local mean time until the year in which they adopted some form of
standardized time.  So local midnight of 1894-01-01 is in fact at an
unusual (for us) offset from UTC.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Wire protocol: type-specific opt-in to binary format
Next
From: Pavel Stehule
Date:
Subject: proposal: use errcontext for custom exception too