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

From Arjen van der Meijden
Subject Re: Is this a bug? : select '26/10/2003'::date + interval '1
Date
Msg-id 000b01c32074$9eb58fe0$3ac15e91@acm
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
Is that the same user on the same machine and on the same database?
If so, than its probably a bug, since CEST and CET have one hour
difference but the timezone shouldn't be changing over time.

Arjen

> -----Oorspronkelijk bericht-----
> Van: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] Namens Conxita Marín
> Verzonden: donderdag 22 mei 2003 12:28
> Aan: Pgsql-General-post (E-mail)
> Onderwerp: [GENERAL] Is this a bug? : select
> '26/10/2003'::date + interval '1 day';
>
>
> 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)
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>



pgsql-general by date:

Previous
From: Hubert Fröhlich
Date:
Subject: postgres and postgis
Next
From: Erik Price
Date:
Subject: Re: PRIMARY KEYS