Re: Is this a bug? : select '26/10/2003'::date + interval '1 day'; - Mailing list pgsql-general

From Richard Huxton
Subject Re: Is this a bug? : select '26/10/2003'::date + interval '1 day';
Date
Msg-id 200305221721.59157.richardh@archonet.com
Whole thread Raw
In response to Is this a bug? : select '26/10/2003'::date + interval '1 day';  (Conxita Marín <comarin@telefonica.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Vincent Hikida"
Date:
Subject: Re: plpgsql recursion
Next
From: Anupama Laxminarayan
Date:
Subject: Disabling autocommit at the psql prompt