Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

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>