Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

SELECT EXTRACT(MONTH FROM TO_DATE(01-JAN-2005 19

SQL>  SELECT EXTRACT(MONTH  FROM TO_DATE('01-JAN-2005 19:15:26','DD-MON-YYYY HH24:MI:SS'))  As MONTH   2  FROM dual;      MONTH ----------          1 SQL>