Re: Year 2000

On Wed, 10 Jul 1996 08:27:00 -0400, Joanne Woytek <joanne_at_daac.gsfc.nasa.gov> wrote:

>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
Massive disclaimer on: I am not saying in any way shape or form the above requested statement is true.... or false...

If you are talking about the database, it doesn't rely on the system clock for anything. It uses an internal clock (SCN = System Commit Number) that doesn't care about the system clock at all.

What other product are you interested in.

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com -- Check out our web site! Brand new, uses Oracle Web Server and Database

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Thu Jul 11 1996 - 00:00:00 CEST