SELECT EXTRACT(YEAR FROM SYSDATE) FROM DUAL;
SELECT EXTRACT(MONTH FROM SYSDATE) FROM DUAL;
SELECT EXTRACT(DAY FROM SYSDATE) FROM DUAL;
SELECT EXTRACT(HOUR FROM TIMESTAMP '2010-10-10 10:10:10') FROM DUAL;
SELECT EXTRACT(MINUTE FROM TIMESTAMP '2010-10-10 10:10:10') FROM DUAL;
SELECT * FROM TABLE a WHERE extract(year from a.createdate)=
#{dateyear} and extract(month from a.createdate)=#{datemonth}