Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

SELECT TO_CHAR(SYSDATE, MM-DD-YYYY HH24

SQL> SQL> SELECT TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS') NOW   2  FROM DUAL; NOW ------------------- 06-19-2008 18:35:50 SQL>