From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: Using YY-MM-DD date input |
Date: | 2003-07-25 21:13:12 |
Message-ID: | 1059167591.26034.171.camel@haggis |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 2003-07-25 at 15:02, Bruce Momjian wrote:
> Does anyone use YY-MM-DD for date input?
>
> Right now, it only works mostly for pre-2000 dates because we can detect
> that 97-02-03 is a year, while we can not detect that in 03-02-01.
>
> We are considering eliminating it for 7.4. You can still use
> yyyy-mm-dd, or course.
>
> Comments?
What about the sliding window approach that some used to "solve"
the y2k problem: any year between, say '00' and '32' is presumed
to be in the 21st century, but years between '33' and '99' are
20th century.
However, dropping it and letting the app deal with it is my non-
counting vote...
--
+-----------------------------------------------------------------+
| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA |
| |
| "I'm not a vegetarian because I love animals, I'm a vegetarian |
| because I hate vegetables!" |
| unknown |
+-----------------------------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-07-25 21:14:24 | Re: Jabber Interface |
Previous Message | Tom Lane | 2003-07-25 20:44:58 | Re: Using YY-MM-DD date input |