oracle yy&RR date

--current date
HR@prod> select to_char(sysdate,'yyyy-mm-dd') from dual;

TO_CHAR(SY
----------
2013-11-06

-- 06-11-95  dd-mm-rr
HR@prod> select to_date('06-11-95','dd-mm-rr') from dual;

TO_DATE('
---------
06-NOV-95

HR@prod> select to_char(to_date('06-11-95','dd-mm-rr'),'yyyy-mm-dd') from dual;

TO_CHAR(TO
----------
1995-11-06

-- 06-11-95 dd-mm-yy
HR@prod> select to_char(to_date('06-11-95','dd-mm-yy'),'yyyy-mm-dd') from dual;

TO_CHAR(TO
----------
2095-11-06

--06-11-20 dd-mm-rr
HR@prod> select to_char(to_date('06-11-20','dd-mm-rr'),'yyyy-mm-dd') from dual;

TO_CHAR(TO
----------
2020-11-06

--06-11-20 dd-mm-yy

HR@prod> select to_char(to_date('06-11-20','dd-mm-yy'),'yyyy-mm-dd') from dual;

TO_CHAR(TO
----------
2020-11-06