Re: Problem with interval - Mailing list pgsql-bugs

From Sean Utt
Subject Re: Problem with interval
Date
Msg-id 006601c4abef$14a35b40$0101a8c0@office.loc
Whole thread Raw
In response to Problem with interval  (Bruno Prévost <bp@interaction.ws>)
List pgsql-bugs
Daylight savings time falls back an hour and 11/01/2004 00:00:00 becomes th=
e answer you got because 10/31/2004 has 25 hours in it. Sort of a bug in "r=
eal time" the interval was correct, but the day was longer than the interva=
l.=20

Sean

  ----- Original Message -----=20
  From: Bruno Pr=E9vost=20
  To: pgsql-bugs@postgresql.org=20
  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

=20=20=20

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Problem with interval
Next
From: Tom Lane
Date:
Subject: Re: Problem with interval