Re: Using YY-MM-DD date input

Heath Tanner wrote:
> On Friday, July 25, 2003, at 04:02 PM, 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.
>
> Does this apply to MM/DD/YY as well, or just the YY-MM-DD variation?
>
> I still have to deal with data (from mainframes) which has some
> dates in MM/DD/YY format, and will have to for the foreseeable
> future.

This only deals with leading years as YY. It doesn't effect trailing YY
at all.
>
> But I always load that type of data into a temp table of text
> columns and "convert" it with a view. As long as I can still CAST a
> YY-MM-DD (actually MM/DD/YY) to a valid date then this would not be
> a problem for me.
>
> I wouldn't be happy to see it dropped (because I know I'll continue
> to have to deal with data with 2-digit years), but I can get around
> it.

Don't worry, we will never get rid of training YY.
\
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073