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 162867790911160733yca15fd9o2dc21bdf88b0f3fa@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>)
Responses Re: different result between 8.3 and 8.5 (to_timestamp function)
List pgsql-hackers
2009/11/16 Tom Lane <tgl@sss.pgh.pa.us>:
> Pavel Stehule <pavel.stehule@gmail.com> writes:
>> It looks like to_timestamp returns some strange timezone value
>
> 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.
>

postgres=# select current_timestamp;             now
───────────────────────────────2009-11-16 16:32:33.225416+01
(1 row)

I am using CET.

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: Tom Lane
Date:
Subject: Re: different result between 8.3 and 8.5 (to_timestamp function)