=?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
Daylight savings time falls back an hour and
11/01/2004 00:00:00 becomes the answer you got because 10/31/2004 has 25 hours
in it. Sort of a bug in "real time" the interval was correct, but the day was
longer than the interval.
Sean
- Original Message -
From:
Bruno Prévo
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
