Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. EXTRACT(SECOND FROM TO_TIMESTAMP(01-JAN-2005 19
SQL>  SELECT
  2    EXTRACT(SECOND FROM TO_TIMESTAMP('01-JAN-2005 19:15:26',
  3      'DD-MON-YYYY HH24:MI:SS')) AS SECOND
  4  FROM dual;
    SECOND
----------
        26
SQL>