Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

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>