BUG #4757: to_timestamp returns incorrect result

Поиск
Список
Период
Сортировка
От Timofey.Asyrkin
Тема BUG #4757: to_timestamp returns incorrect result
Дата
Msg-id 200904111906.n3BJ65G2072403@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4757: to_timestamp returns incorrect result  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4757
Logged by:          Timofey.Asyrkin
Email address:      timoha-tim@ngs.ru
PostgreSQL version: 8.3
Operating system:   Ubuntu 8.10
Description:        to_timestamp returns incorrect result
Details:

Hello everybody,

It looks like there is a bug in to_timestamp function:
I'm living in Italy and I have a timezone GMT+2 (summer).
These two queries return the same result:

1)select TO_TIMESTAMP( '25/03/2001 02:00:00', 'dd/mm/yyyy hh24:mi:ss' );
2)select TO_TIMESTAMP( '25/03/2001 03:00:00', 'dd/mm/yyyy hh24:mi:ss' );

Result: 2001-03-25 03:00:00+02

Having executed with different date, but the same time didn't gave such
result, moreover, changing the timezone gives correct result.

Kind regards,
Timofey

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: libpq 8.4 beta1: $PGHOST complains about missing root.crt
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4757: to_timestamp returns incorrect result