Oracle 函数获取时间的年份和月份
获取年份
SELECT extract(year from sysdate) from dual;
获取月份
SELECT extract(month from sysdate) from dual;