Re: [BUGS] BUG #1768: to_char result of an interval differs between

2005-08-17 Thread Bruce Momjian
Alvaro Herrera wrote: > On Thu, Jul 14, 2005 at 08:01:11AM +0100, [EMAIL PROTECTED] wrote: > > > 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', 'MMDD HH24:MI:SS')" > > Result of a 8.0.3: "0001 1

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

2005-07-14 Thread Alvaro Herrera
On Thu, Jul 14, 2005 at 08:01:11AM +0100, [EMAIL PROTECTED] wrote: > 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', 'MMDD HH24:MI:SS')" > Result of a 8.0.3: "0001 15:02:12" > The error in the Result i