Re: Year 2000

From: L120bj <l120bj_at_aol.com>
Date: 1997/04/13
Message-ID: <19970413120601.IAA08877@ladder01.news.aol.com>#1/1

If the default date format for the database is defined as DD-MON-YY then the date 10-APR-00 will be stored on the database as 10th April 1900. There are a number of things that need to be done to prevent this. i) Get the DBA to set the NLS_DATE_FORMAT init.ora parameter to DD-MON-RR.
ii) Check any programs that specifically perform date conversions or apply date format masks (eg Forms45), to ensure that they also use the RR format rather than the YY format.
iii) Check whether any dates to be entered into the system fall between 1900 and 1949, eg date of birth. In these circumstances the new format would cause them to be stored as 2000-2049, since the RR format is something of a fudge. For any such fields then you have to choices :-

Force them to the YY format before insert/update of the database.
Force user input to be a four digit year.

Hope this helps, if anything is unclear, or you need any more info. then mail me.

Rob

Subject: Re: Year 2000
From: "Lun Wing San (Oracle)" <wslun_at_qrcsun.qrc.org> Date: Sat, 12 Apr 1997 18:14:11 -0700
Message-ID: <33503363.665D_at_qrcsun.qrc.org>

Judy Lam wrote:
>
> Does anyone know how Oracle handles the year 2000?
>
> Currently, years are entered into the database as '10-APR-97'. How are
> dates entered for the year 2000. Is it '10-APR-00'?

You can display the date in the format 'DD-MM-YYYY' to determine whether it is correct
or not. The default date format mask is 'DD-MM-YY' if the the territory is AMERICA

***
* *
* Please go to http://www.hkstar.com/~rdbms/oracle.htm to find out solutions*
*

 *
**************************************************************************
***

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when
you
opened this article and I will not be responsible for its contents or use.

Received on Sun Apr 13 1997 - 00:00:00 CDT