Postgres Pro
Downloads
Home   >   mailing lists

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

From Conxita Marín
Subject Is this a bug? : select '26/10/2003'::date + interval '1 day';
Date
Msg-id 000001c3204c$c5984580$0cd8a8c0@dims
Whole thread Raw
Responses Re: Is this a bug? : select '26/10/2003'::date + interval '1  (Arjen van der Meijden <acm@tweakers.net>)
Re: Is this a bug? : select '26/10/2003'::date + interval '1 day';  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Is this a bug? : select '26/10/2003'::date + interval  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Is this a bug? : select '26/10/2003'::date + interval '1 day';  (Richard Huxton <richardh@archonet.com>)
List pgsql-general
Tree view 
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)

pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Binary files in CVS
Next
From: Darko Prenosil
Date:
Subject: Re: caching query results