3 digit ISO dates - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject 3 digit ISO dates
Date
Msg-id 00c701c37b58$6cebff50$2800a8c0@mars
Whole thread Raw
Responses Re: 3 digit ISO dates  (Andreas Joseph Krogh <andreak@officenet.no>)
List pgsql-hackers
Hi,

Are we going to address the fact that you can't enter 3 digit years without
a leading 0?

australia=# select '111-01-01'::date;
ERROR:  Bad date external representation '111-01-01'

australia=# select '0111-01-01'::date;   date
------------0111-01-01
(1 row)

I can't see any reason why we shouldn't allow it???

Chris



pgsql-hackers by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: Vote: Adding flex/bison derived files in WIN32_DEV
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: 3 digit ISO dates