Date not being parsed as expected

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Date not being parsed as expected
Date: 2002-09-06 07:24:23
Message-ID: 3D785827.8010805@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message frbn 2002-09-06 07:27:46 Re: installation
Previous Message Bruno Wolff III 2002-09-06 07:09:21 Making small bits of code available