Problem with interval

From: Bruno Prévost <bp(at)interaction(dot)ws>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Problem with interval
Date: 2004-10-06 20:26:06
Message-ID: 039801c4abe2$b5715ac0$5d00a8c0@BRUNO2500
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Fuhr 2004-10-06 21:47:55 Re: Problem with interval
Previous Message Bruce Momjian 2004-10-06 17:23:29 Re: pg_dumpall bug in PG 8.0b3 Win32 port