Is this what you want...

Code:
SQL>SELECT to_char(sysdate,'dd Mon YYYY HH24:MI:SS') from dual;

TO_CHAR(SYSDATE,'DDM
--------------------
19 Mar 2003 15:46:17