Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Y2K QUESTION automatic conversion
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 Tue May 05 1998 - 19:44:13 CDT