select to_char(sysdate, 'yyyy') from dual;
select to_char(sysdate, 'mm') from dual;
select to_char(sysdate, 'dd') from dual;
select to_char(sysdate, 'yyyy') from dual;
select to_char(sysdate, 'mm') from dual;
select to_char(sysdate, 'dd') from dual;
转载于:https://www.cnblogs.com/wanglibo/archive/2012/02/03/2336741.html