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
>
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? |