Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

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> -