Postgres Pro
Downloads
Home   >   mailing lists

BUG #1768: to_char result of an interval differs between 7.x and 8.x - Mailing list pgsql-bugs

From
Subject BUG #1768: to_char result of an interval differs between 7.x and 8.x
Date
Msg-id 20050714070111.54E78F0B13@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1768: to_char result of an interval differs between 7.x and 8.x  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: Stefan Miefert
Date:
Subject: [postgres] Datumsfeld leer lassen
Next
From: Tom Lane
Date:
Subject: Re: BUG #1769: pg_dumpall fails to run