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

sysdate
-----------
03-SEP-2009