On Thu, 22 May 2003, [iso-8859-1] Conxita Marn wrote:
> Hi.
>
> Is this a bug?
>
> s001=> select '25/10/2003'::date + interval '1 day';
> ?column?
> --------------------------
> 26/10/2003 00:00:00 CEST
> (1 row)
>
> s001=> select '26/10/2003'::date + interval '1 day';
> ?column?
> -------------------------
> 26/10/2003 23:00:00 CET (????)
> (1 row)
Is that your daylight savings time changeover point (appears to be from
the output, but it's worth checking). IIRC '1 day' is taken as equivalent
to 24 hours which because of the time zone switch causes the above (it'd
presumably be 27/10/2003 00:00:00 CEST but that's not your timezone
anymore).