Re: Year 2000

James B. Reynolds wrote:
>
> In <31E2ACC7.59EB_at_daac.gsfc.nasa.gov> Joanne Woytek
> <joanne_at_daac.gsfc.nasa.gov> writes:
> >
> >Does anyone know if Oracle is or claims to be year 2000 compliant;
> >i.e. when the date is 01/01/00, will all Oracle provided programs
> >including internal system routines and application callable routines
> >function correctly?
> >--
> >Joanne Woytek
> >joanne_at_daac.gsfc.nasa.gov
> >Code 902
> >NASA/GSFC
>
> Joanne,
>
> Look in the Oracle 7 SQL Language Reference Manual re date format
> elements. Look at the use of the 'RR' element as opposed to 'YY'
>
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

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"

-- 
Joanne Woytek
joanne_at_daac.gsfc.nasa.gov
Code 902
NASA/GSFC