Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. 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>