Skip site navigation (1) Skip section navigation (2)

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

From: "" <michael(dot)oeztuerk(at)haufe(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1768: to_char result of an interval differs between 7.x and 8.x
Date: 2005-07-14 07:01:11
Message-ID: 20050714070111.54E78F0B13@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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"

Responses

pgsql-bugs by date

Next:From: Stefan MiefertDate: 2005-07-14 10:40:16
Subject: [postgres] Datumsfeld leer lassen
Previous:From: THILANKADate: 2005-07-14 03:03:51
Subject: BUG #1767: Trigger handling

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group