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-49 | If the specified two digit year is 50-99 | |
|---|---|---|
| If the two digits of current year is 0-49 | The 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-99 | The return date is in the century before the current one. | The return date is in the current century. |
Examples:
| Current Year | Given Date | Interpreted (RR) - Year |
|---|---|---|
| 1999 | 03-MAR-85 | 2085 |
| 2001 | 03-MAR-95 | 1995 |
| 2007 | 03-MAR-09 | 2009 |
| 2048 | 03-MAR-50 | 1950 |
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:
Post a Comment