Re: Year 2000

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.