The following bug has been logged online:
Bug reference: 1768
Logged by:
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
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 its "one year behind".
The same statement given to a 7.3.4 delivers the correct result: "00000000
15:02:12"