Re: Y2K QUESTION automatic conversion

In article <354FB25D.17E4_at_dsp35001.ca.boeing.com>, Doug Henderson <dough_at_dsp35001.ca.boeing.com> wrote:
>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?

Yes it will work. What I have found is that if you do not specify the century in a date, the century gets set to the century of the date on the client.

But I think you should beware: What if your user needs to insert a future or prior date that is in a different century? If you enter 05-JAN-00 now, it will be stored as 05-JAN-1900. And after 01-JAN-2000, if you enter 01-DEC-99, it will be stored as 01-DEC-2099.

Your approach will ONLY work if all the dates entered are for the current day!

Regards,
Steve Cosner Received on Thu May 07 1998 - 16:23:06 CDT