3 digit ISO dates

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: 3 digit ISO dates
Date: 2003-09-15 07:09:32
Message-ID: 00c701c37b58$6cebff50$2800a8c0@mars
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Joseph Krogh 2003-09-15 07:44:38 Re: 3 digit ISO dates
Previous Message Andrew Dunstan 2003-09-15 07:03:08 Re: Vote: Adding flex/bison derived files in WIN32_DEV