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

TO_CHAR(SYS
-----------
03-SEP-2009