Re: Y2k Server Testing, What's in a date?

I'm doing Y2K consulting for a huge worldwide company. In regards to the Oracle Databases, we are just replacing the 7.1 version to 7.3. One of the issues is, Are the personalized applications Y2K compliant? What happens when a user enter the following dates: September 9, 1999 (9999 used to denote invalid data) January 1, 2000 February 29, 2000 (400 hundred exception, to 100 year exception to 4 year leap year rule.)

Wondering if the Oracle databases are Y2k compliant is just part of our problem, we have personalized applications and every type of Operating System imaginable. God help us, we have to take a detailed inventory of every piece of equipment the Company owns.

Anyway, my 2 cents...
Satar Naghshineh
October 10, 2000 (First eight digit date) In article <642T1.6$c47.43873_at_newsread.com>,   "Mike Oswald" <minomaha_at_hotmail.com> wrote:
> With all of the Y2K testing planned here at work and the fact that someone
> has determined all the DBA's need to do is change the NLS date format...
>
> What is everyone else doing? How involved have you, as a DBA, or has your
> DBA's been in the Y2K process?
>
> Is it simply a NLS data format change? It seems to me... there is more to
> it.
>
> Please forward any suggestions... websites... comments on what I should be
> thinking about. We do have Developer & Designer 2000 in house... but they
> are not the core business tools. Oracle7 is primarily the backend database
> but we do have snapshots and some replication occurring.
>
> Thanks!
>
> -Mike
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 08 1998 - 12:29:40 CDT