SQL> select to_char(sysdate, 'DD-MON-YY') from dual;

TO_CHAR(S
---------
13-DEC-00

SQL> select to_char (sysdate, 'DD-MON-RRRR') from dual;

TO_CHAR(SYS
-----------
13-DEC-2000

SQL>