Re: Year 2000

Oracle appears to always default to 1900 if you give it a two digit year.

                         Mike

Lun Wing San (Oracle) wrote:
>
> 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 Mon Apr 14 1997 - 00:00:00 CDT