Did Oracle have a problem with Y2K?

Question

I guess this is not so, because they use centuries also in dates

From here ,

The DATE data type stores the year (including century) , month, day, hours, minutes, and seconds (after midnight).

Whether faced with a problem ?

Answer 1

, Oracle Y2K. Oracle 7 . , Oracle 7 DD-MON-YY . , . . , , .

Oracle RR , . . , . , , , .

, .

SQL> insert into t72 values (1, to_date('12-MAY-32', 'DD-MON-YY'))
  2  /

1 row created.

SQL> insert into t72 values (2, to_date('12-MAY-99', 'DD-MON-YY'))
  2  /

1 row created.

SQL> insert into t72 values (3, to_date('12-MAY-50', 'DD-MON-YY'))
  2  /

1 row created.

SQL> insert into t72 values (11, to_date('12-MAY-32', 'DD-MON-RR'))
  2  /

1 row created.

SQL> insert into t72 values (12, to_date('12-MAY-99', 'DD-MON-RR'))
  2  /

1 row created.

SQL> insert into t72 values (13, to_date('12-MAY-50', 'DD-MON-RR'))
  2  /

1 row created.

SQL> insert into t72 values (14, to_date('12-MAY-49', 'DD-MON-RR'))
  2  /

1 row created.

SQL>

:

SQL> alter session set nls_date_format = 'DD-MON-YYYY'
  2  /

Session altered.

SQL> select * from t72
  2  /

        ID D
---------- -----------
         1 12-MAY-2032
         2 12-MAY-2099
         3 12-MAY-2050
        11 12-MAY-2032
        12 12-MAY-1999
        13 12-MAY-1950
        14 12-MAY-2049

7 rows selected.

SQL>

1-49 19 0, 50-99 20.

---

, Oracle Y2K - , . - , 14-OCT-09 . , RR , .

Answer 2

APC, Oracle V7, YY 2K.

, , 2K, YY , - Y2K - // - :

TO_DATE(TO_CHAR(a_date_column,'DD-MM-YY')||'12:00','DD-MM-YYHH24:MI')

, , . Oracle, .

, , Oracle, NLS. , DBA , -YY, , , JDBC -YY, .

Oracle, , "Y2K" , 2- .

Answer 3

, , :

http://news.cnet.com/Oracle-offers-free-Y2K-upgrade/2100-1001_3-222123.html

, , .

Answer 4

, ....

Oracle Y2K, .

- , Oracle Y2K. .:)

, Y2K. ( , RDBMS, )