Re: Is this a bug? : select '26/10/2003'::date + interval '1

From: Arjen van der Meijden <acm(at)tweakers(dot)net>
To: cmarin(at)dims(dot)com, "'Pgsql-General-post (E-mail)'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is this a bug? : select '26/10/2003'::date + interval '1
Date: 2003-05-22 15:12:48
Message-ID: 000b01c32074$9eb58fe0$3ac15e91@acm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erik Price 2003-05-22 15:20:28 Re: PRIMARY KEYS
Previous Message scott.marlowe 2003-05-22 14:53:10 Re: SELECT DISTINCT ON bug?