On Thursday 22 May 2003 11:27 am, Conxita Marín 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)
If CEST is Central European Summer Time
And CET is Central European Time
Then I'd guess you're looking at the end of the summer-time adjustment when
the clocks go back 1 hour.
--
Richard Huxton
Archonet Ltd