to_date(SYSDATE,'DD-MON-YYYY RR')

[dknight]

Try either one of these:

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

select to_char(sysdate, 'DD-MON-YYYY') from dual;

to_char and not to_date

Good luck.