Help for this page
SQL> select to_char(sysdate, 'DD-MON-YYYY') from dual; TO_CHAR(SYS ----------- 03-SEP-2009
SQL> select to_char(sysdate, 'DD-MON-YYYY') "sysdate" from dual; sysdate ----------- 03-SEP-2009