获取时间年月日

select to_char(sysdate, 'yyyy') from dual;

 select to_char(sysdate, 'mm') from dual;

 select to_char(sysdate, 'dd') from dual;