Re: Problem with interval

Daylight savings time falls back an hour and 11/01/2004 00:00:00 becomes the answer you got because 10/31/2004 has 25 hours in it. Sort of a bug in "real time" the interval was correct, but the day was longer than the interval.

Sean

----- Original Message -----
From: Bruno Prévost
To: pgsql-bugs(at)postgresql(dot)org
Sent: Wednesday, October 06, 2004 1:26 PM
Subject: [BUGS] Problem with interval

Hi,

I'm using postgres version 7.4.5 and had a problem with interval

Here is my query :
select '2004/10/31'::timestamptz + '1 day'::interval;

Here is the answer :
10/31/2004 11:00:00 PM

Is it a bug or I do something wrong?
I tested my query on 3 server and have always the same answer.

Thanks
Regards