Re: Using YY-MM-DD date input

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 |
+-----------------------------------------------------------------+

In response to

Responses

Browse pgsql-general by date

  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