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