Re: Problem with interval

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