Re: [BUGS] Problem with interval

2004-10-06 Thread Tom Lane
=?iso-8859-1?Q?Bruno_Pr=E9vost?= <[EMAIL PROTECTED]> writes: > 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 If you are in a US time zone then that's th

Re: [BUGS] Problem with interval

2004-10-06 Thread Sean Utt
: Bruno Prévost To: [EMAIL PROTECTED] 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

Re: [BUGS] Problem with interval

2004-10-06 Thread Michael Fuhr
On Wed, Oct 06, 2004 at 04:26:06PM -0400, Bruno Pr?vost wrote: > > 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 I'd guess that Daylight Saving Tim

[BUGS] Problem with interval

2004-10-06 Thread Bruno Prévost
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.