Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. SELECT EXTRACT(YEAR FROM TO_DATE(01-JAN-2005 19
SQL>  SELECT EXTRACT(YEAR  FROM TO_DATE('01-JAN-2005 19:15:26','DD-MON-YYYY HH24:MI:SS')) AS YEAR
  2  FROM dual;
      YEAR
----------
      2005
SQL>