Re: different result between 8.3 and 8.5 (to_timestamp function)

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: different result between 8.3 and 8.5 (to_timestamp function)
Дата
Msg-id 162867790911160733yca15fd9o2dc21bdf88b0f3fa@mail.gmail.com
обсуждение исходный текст
Ответ на Re: different result between 8.3 and 8.5 (to_timestamp function)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: different result between 8.3 and 8.5 (to_timestamp function)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: different result between 8.3 and 8.5 (to_timestamp function)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: different result between 8.3 and 8.5 (to_timestamp function)