The following bug has been logged online:
Bug reference: 1768
Email address: michael(dot)oeztuerk(at)haufe(dot)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
When using the following SQL statement the result of a 8.0.3 seems to be
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 its "one year behind".
The same statement given to a 7.3.4 delivers the correct result: "00000000
pgsql-bugs by date
|Next:||From: Stefan Miefert||Date: 2005-07-14 10:40:16|
|Subject: [postgres] Datumsfeld leer lassen|
|Previous:||From: THILANKA||Date: 2005-07-14 03:03:51|
|Subject: BUG #1767: Trigger handling|