Re: [BUGS] Problem with interval

Wed, 06 Oct 2004 14:51:36 -0700

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 -----
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

 
 

Reply via email to