Mega Code Archive
Categories
/
Oracle PLSQL
/
Data Type
Format current system date
SQL> SQL> SELECT TO_CHAR(SYSDATE, 'dd Mon, yyyy hh24:mi:ss') FROM dual; TO_CHAR(SYSDATE,'DDMO --------------------- 30 Aug, 2006 19:57:11 SQL>