Oracle 函数获取时间的年份和月份

获取年份

SELECT extract(year from TRAINING_START_TIME) from WF_PLAN_BOOK where mainid=4167;

获取月份

SELECT extract(month from TRAINING_START_TIME) from WF_PLAN_BOOK where mainid=4167;