The following example gets the current date and time from the database using the SYSDATE function.
Converts it to a string using TO_CHAR() with the format MONTH DD, YYYY, HH24:MI:SS.
The time portion of this format indicates that the hours are in 24-hour format.
SQL>
SQL> SELECT TO_CHAR(SYSDATE, 'MONTH DD, YYYY, HH24:MI:SS')
2 FROM dual;
TO_CHAR(SYSDATE,'MONTHDD,YYY
----------------------------
MAY 30, 2007, 21:29:42
SQL>