Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. EXTRACT() gets the hour, minute, and second from a TIMESTAMP returned by TO_TIMESTAMP()
SQL>
SQL> SELECT
  2    EXTRACT(HOUR FROM TO_TIMESTAMP('01-JAN-2005 19:15:26',
  3      'DD-MON-YYYY HH24:MI:SS')) AS HOUR
  4  FROM dual;
      HOUR
----------
        19
SQL>
-