1.å½åæ¥æç年份第ä¸å¤©åæåä¸å¤©
第ä¸å¤©
select trunc(sysdate,'y') FROM DUAL;
select trunc(sysdate,'yy') FROM DUAL;
select trunc(sysdate,'yyy') FROM DUAL;
select trunc(sysdate,'yyyy') FROM DUAL;
æåä¸å¤©
select last_day(add_months(trunc(SYSDATE,'y'),11)) from dual
2.å½åæ¥æçæ份第ä¸å¤©åæåä¸å¤©
select trunc(sysdate,'MM') from dual;
select last_day(sysdate) from dual;
温馨提示:答案为网友推荐,仅供参考