BUG #1768: to_char result of an interval differs between 7.x and 8.x

Поиск
Список
Период
Сортировка
От
Тема BUG #1768: to_char result of an interval differs between 7.x and 8.x
Дата
Msg-id 20050714070111.54E78F0B13@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #1768: to_char result of an interval differs between 7.x and 8.x  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged online:

Bug reference:      1768
Logged by:
Email address:      michael.oeztuerk@haufe.de
PostgreSQL version: 8.0.3
Operating system:   Linux / Debian (Version 3.0)
Description:        to_char result of an interval differs between 7.x and
8.x
Details:

When using the following SQL statement the result of a 8.0.3 seems to be
wrong.

Statement: "select to_char(interval '15h 2m 12s', 'YYYYMMDD HH24:MI:SS')"
Result of a 8.0.3: "00010000 15:02:12"
The error in the Result is that it´s "one year behind".

The same statement given to a 7.3.4 delivers the correct result: "00000000
15:02:12"

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

Предыдущее
От: Stefan Miefert
Дата:
Сообщение: [postgres] Datumsfeld leer lassen
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #1769: pg_dumpall fails to run