Re: Year 2000

In article <31E3A194.4A51_at_daac.gsfc.nasa.gov>, Joanne Woytek <joanne_at_daac.gsfc.nasa.gov> wrote:

>My question is more in terms of internal Oracle structure and not how
>my application will handle the year 2000. Has Oracle certified /
>tested / claimed / verfied that Oracle 7 will not have any errors
>associated with the year 2000? For example, in light of the above
>response, has Oracle verfied that it internally uses RR format or
>otherwise avoids year 2000 type problems in all of its code?
>While I do not know the internal Oracle code to know where there might
>be problems, an application orinted question is: on 01/01/00 will the
>following equation return a 1:
 

> sysdate - last_day_1999
 

Yes, it should return a 1. The internal date is not based on RR format but rather is based on days since December 31, 4713 BC (fractions are included to indicate time of day).

>But this is not just a question in terms of that equation, but in
>terms of the entire Oracle internal structure. I guess what I am
>looking for is an Oracle, Corp statement along the lines of:
>"All Oracle products have been tested and verified to correctly
>function during the year switch from 1999 to 2000"
 

I have a feeling that Oracle is year2000 compliant. Here we have changed the default date format from: 'dd-mon-yy' to 'dd-mon-yyyy', etc. If you still use last two digits of a year, using 'rr' format may be a good idea. But I prefer to use all four digits of a year.

According to an Oracle manual, Oracle can handle dates from January 1, 4712 BC to December 31, 4712 AD. This should include the year 2000.

-- 
Bernard Tiffany                      
Internet: Bernard.Tiffany_at_umich.edu                     CompuServe: 75046.2667 
Countdown to Victory '96