5天前的日期
select TO_CHAR(SYSDATE-5,'YYYY-MM-DD') from dual;
十年前的本月
SELECT TO_CHAR(ADD_MONTHS(TRUNC(SYSDATE,'YYYY'),-120),'YYYYMM') INTO BEGIN_MONTH FROM DUAL;
本年的末月
SELECT TO_CHAR(SYSDATE,'YYYY')||'12' INTO END_MONTH FROM DUAL;
5天前的日期
select TO_CHAR(SYSDATE-5,'YYYY-MM-DD') from dual;
十年前的本月
SELECT TO_CHAR(ADD_MONTHS(TRUNC(SYSDATE,'YYYY'),-120),'YYYYMM') INTO BEGIN_MONTH FROM DUAL;
本年的末月
SELECT TO_CHAR(SYSDATE,'YYYY')||'12' INTO END_MONTH FROM DUAL;