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.
pgsql-bugs by date
|Next:||From: Michael Fuhr||Date: 2004-10-06 21:47:55|
|Subject: Re: Problem with interval|
|Previous:||From: Bruce Momjian||Date: 2004-10-06 17:23:29|
|Subject: Re: pg_dumpall bug in PG 8.0b3 Win32 port|