Re: Year 2000
Date: 1996/07/10
Message-ID: <31E420B5.21CC_at_hal.com>#1/1
Joanne Woytek wrote:
>
> 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
No problem at all. Oracle is good til 4017 AD I think. Oracle's
internal date format is actual a Julian like date and time to the
second. It's greate for the year 2000 but it causes problems and some
extra work on comparisions because MYDATE1=MYDATE2 will not return true
if they both aren't the same to the second. They look the same on the
default dd-mmm-yy format but they are different. To see the difference
you must use TO_CHAR(MYDATE1,'DD-MON-YYYY HH24:MI:SS') to see the entire
date value.
-ed
- Ed Kulis 408-341-5561 Hal Computer Systems
- Sr. Oracle DBA ekulis_at_hal.com Campbell, CA 95008
- I would like it to be known that all opinions that are shown
- are exclusively my own, on my own, all my own.