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

From: Conxita Marín <comarin(at)telefonica(dot)net>
To: "Pgsql-General-post (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Is this a bug? : select '26/10/2003'::date + interval '1 day';
Date: 2003-05-22 10:27:38
Message-ID: 000001c3204c$c5984580$0cd8a8c0@dims
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Heinrich 2003-05-22 10:27:42 User and Timestamps
Previous Message Richard Huxton 2003-05-22 09:27:21 Re: compiling mod_auth_pgsql