Re: different result between 8.3 and 8.5 (to_timestamp function) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: different result between 8.3 and 8.5 (to_timestamp function)
Date
Msg-id 19512.1258386238@sss.pgh.pa.us
Whole thread Raw
In response to Re: different result between 8.3 and 8.5 (to_timestamp function)  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: different result between 8.3 and 8.5 (to_timestamp function)
List pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> 2009/11/16 Tom Lane <tgl@sss.pgh.pa.us>:
>> What timezone setting are you using?  I'd bet a great deal that
>> +00:57:44 is what the Olsen database shows as the LMT offset for
>> your zone before standardized timezones were adopted.

> I am using CET.

"CET" covers a multitude of sins, but I suspect it's specifically
Europe/Prague:

# Zone    NAME        GMTOFF    RULES    FORMAT    [UNTIL]
Zone    Europe/Prague    0:57:44 -    LMT    1850        0:57:44    -    PMT    1891 Oct     # Prague Mean Time
1:00   C-Eur    CE%sT    1944 Sep 17 2:00s        1:00    Czech    CE%sT    1979        1:00    EU    CE%sT
 

So midnight local time corresponds to 00:57:44 GMT before 1891.
If you think this is wrong, use another zone, or take it up with
the zic folk.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: different result between 8.3 and 8.5 (to_timestamp function)
Next
From: Pavel Stehule
Date:
Subject: Re: different result between 8.3 and 8.5 (to_timestamp function)