BUG #12739: to_timestamp function conver string to time incorrectly

Поиск
Список
Период
Сортировка
От lstrupinskaya@gmail.com
Тема BUG #12739: to_timestamp function conver string to time incorrectly
Дата
Msg-id 20150205212231.24252.12016@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #12739: to_timestamp function conver string to time incorrectly
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12739
Logged by:          Liliya
Email address:      lstrupinskaya@gmail.com
PostgreSQL version: 9.3.6
Operating system:   Windows
Description:

When trying to use to_timestamp function to convert string '3/10/2013 2:30'
to timestamp it was actually converted into 3/10/2013 3:30.

Below is select statement:

select to_timestamp('3/10/2013 2:30','MM/DD/YYYY HH24:MI');

it seems that problem was caused by days when daylight time is switched. all
following and preceding hours where properly converted.

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

Предыдущее
От: barrera@mail.bpa.cu
Дата:
Сообщение: BUG #12743: error in xml conversion
Следующее
От: anjana1909@gmail.com
Дата:
Сообщение: BUG #12742: non fatal error during istallation