提取年

select extract(year from sysdate) from dual

原文地址:https://www.cnblogs.com/nuaaydh/p/9125636.html