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