Monday, July 2, 2007

Future Userbility Problem in Oracle Y2K Solution

Today at the Oracle Class we did about Date formats in Oracle. And the Oracle's solution for Y2K Problem is RR instead of YY.
Here what happens,


If the specified two digit year is 0-49If the specified two digit year is 50-99
If the two digits of current year is 0-49The return date is in the current century.The return date is in the century before the current one.
If the two digits of current year is 50-99The return date is in the century before the current one.The return date is in the current century.

Examples:

Current YearGiven DateInterpreted (RR) - Year
199903-MAR-852085
200103-MAR-951995
200703-MAR-092009
204803-MAR-501950

The usability problem occurs when you reach the middle of the century, in the example I have noted in red. In 2048, 03-MAR-50 is interpreted by 1950. But in 2048, 03-MAR-50 will clealy mean 2050 in common use. So according to my knowledge their is a future usability problem exists in Oracles's RR date format. It's solutions for the Y2K problem.

References:
Introduction to Oracle9i: SQL (Student Guide - Volume 1) - 2001 - Oracle Corporation

Oracle is a trademark of Oracle Corporation.

0 comments: