Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

EXTRACT(MINUTE FROM TO_TIMESTAMP(01-JAN-2005 19

SQL>  SELECT   2    EXTRACT(MINUTE FROM TO_TIMESTAMP('01-JAN-2005 19:15:26',   3      'DD-MON-YYYY HH24:MI:SS')) AS MINUTE   4  FROM dual;     MINUTE ----------         15 SQL>