Re: Y2K QUESTION automatic conversion

No, the reason this works currently is your NLS_DATE format has set to 2 digit years.
You have the choice of either changing the NLS_DATE format or performing a to_date with 4 digit year picture.

Barry Jones
Logica UK Ltd.

Doug Henderson <dough_at_dsp35001.ca.boeing.com> wrote in article <354FB25D.17E4_at_dsp35001.ca.boeing.com>...
> A Y2K-related question about automatic conversion of data types:
>
> I understand that Oracle automatically converts a CHAR string to DATE
> if the CHAR string is in the "default Oracle" (i.e., DD-MON-YY)
> format. So, an insert like the following will work in SQL*PLUS:
>
> INSERT INTO some_table (st_date) /* st_date is a DATE column */
> VALUES '05-MAY-98';
>
> The year for the date inserted by the above statement will end up
> as 1998 in the database.
>
> My question is, will such automatic conversion work correctly after
> 1/1/2000? In other words, will the century portion of the year for
> such an insert automatically be the 21st century after 1/1/2000?
>
> Thanks in advance!
>
Received on Wed May 06 1998 - 06:46:19 CDT