oracle获取年月日函数

select count(*) from PP_GWBARCODERR 
where extract(year from createdate) = extract(year from sysdate)
and
extract(month from createdate) = extract(month from sysdate)
and
extract(day from createdate) = extract(day from sysdate);