oralce 月份 获取

获取本年到当前时间的月份

select to_char(add_months(sysdate, -t.rn), 'yyyymm')
  from dual a, (select rownum - 1 rn from dual connect by rownum <= 12) t
 where to_char(add_months(sysdate, -t.rn), 'yyyy') =
       to_char(sysdate, 'yyyy')
 order by to_char(add_months(sysdate, -t.rn), 'yyyymm')；

 

 

 

 

select to_date(add_months(sysdate, -1)) from dual;

select to_date(add_months(sysdate, -12)) from dual;

SELECT ADD_MONTHS(sysdate, -12) as 去年的今天,
       ADD_MONTHS(sysdate, 12) as 明年的今天
  FROM dual