Xref: alice comp.databases.oracle.server:20340
Newsgroups: comp.databases.oracle.server
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!Supernews73!Supernews60!supernews.com!uunet!in3.uu.net!xyzzy!nntp
From: Doug Henderson <dough@dsp35001.ca.boeing.com>
Subject: Y2K QUESTION automatic conversion
Content-Type: text/plain; charset=us-ascii
Message-ID: <354FB25D.17E4@dsp35001.ca.boeing.com>
Sender: nntp@news.boeing.com (Boeing NNTP News Access)
Reply-To: dough@dsp35001.ca.boeing.com
Content-Transfer-Encoding: 7bit
Organization: The Boeing Company
Mime-Version: 1.0
Date: Wed, 6 May 1998 00:44:13 GMT
X-Mailer: Mozilla 3.0 (Win95; I)
Lines: 18

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!