Postgres Pro
Downloads
Home   >   mailing lists

Problem with interval - Mailing list pgsql-bugs

From Bruno Prévost
Subject Problem with interval
Date
Msg-id 039801c4abe2$b5715ac0$5d00a8c0@BRUNO2500
Whole thread Raw
Responses Re: Problem with interval  (Michael Fuhr <mike@fuhr.org>)
Re: Problem with interval  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
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

 
 

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1281: I cannot find the ODBC driver in available ODBC drivers
Next
From: Michael Fuhr
Date:
Subject: Re: Problem with interval