Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Y2K QUESTION automatic conversion

Y2K QUESTION automatic conversion

From: Doug Henderson <dough_at_dsp35001.ca.boeing.com>
Date: Wed, 6 May 1998 00:44:13 GMT
Message-ID: <354FB25D.17E4@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 Tue May 05 1998 - 19:44:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US