Extract year, month, day from a date : EXTRACT « Date Timestamp Functions « Oracle PL/SQL Tutorial
SQL> create table emp 2 ( empno NUMBER(4) constraint E_PK primary key 3 , ename VARCHAR2(8) 4 , init VARCHAR2(5) 5 , job VARCHAR2(8) 6 , mgr NUMBER(4) 7 , bdate DATE 8 , sal NUMBER(6,2) 9 , comm ......