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

From Pavel Stehule
Subject Re: different result between 8.3 and 8.5 (to_timestamp function)
Date
Msg-id 162867790911160804r6112a62ay3b057b3ab2d4fd52@mail.gmail.com
Whole thread Raw
In response to Re: different result between 8.3 and 8.5 (to_timestamp function)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
2009/11/16 Tom Lane <tgl@sss.pgh.pa.us>:
> 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.
>

ok - I understand.

Thank you

Pavel

>                        regards, tom lane
>


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: different result between 8.3 and 8.5 (to_timestamp function)
Next
From: "Kevin Grittner"
Date:
Subject: Re: Summary and Plan for Hot Standby