Date not being parsed as expected - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject Date not being parsed as expected
Date
Msg-id 3D785827.8010805@mega-bucks.co.jp
Whole thread Raw
Responses Re: Date not being parsed as expected  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Date not being parsed as expected  (Mario Weilguni <mweilguni@sime.com>)
List pgsql-general
The following insert:

insert into t values('01-10-29')

gives the following result in the DB:

select * from t
      d
------------
  2029-01-10

Why is the first part (01) being parsed as the month? The DateStyle is
set to ISO (the default) so shoudln't the parser see xx-yy-zz as being
year-month-day?

Thanks,

Jc


pgsql-general by date:

Previous
From: frbn
Date:
Subject: Re: installation
Next
From: Christoph Dalitz
Date:
Subject: Re: Issues on OSX - Jaguar