Re: result of conversion to timestamp is shifted 1 minute back

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: result of conversion to timestamp is shifted 1 minute back
Дата
Msg-id 3AD45DD1.25939489@alumni.caltech.edu
обсуждение исходный текст
Ответ на result of conversion to timestamp is shifted 1 minute back  (pgsql-bugs@postgresql.org)
Список pgsql-bugs
> When postgresql converts string representation of date to timestamp, he make one minute back error. Any insert or
updatewith string date representation damage real value of date! 
> BUT if you use string date representation without time part, your data will be shifted one day back!!!
> Tested on RedHat 7.0, PostgreSQL 7.0.3

We will need more details on your installation to be able to help, since
this is *not* reproducible on most systems. We've never heard of this
before!

                      - Thomas

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

Предыдущее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: result of conversion to timestamp is shifted 1 minute back
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: reltime with NULL fields crashes backend