add_months(增加或减去月份 ) select to_char(add_months(to_date('1999-12-01','yyyy-mm-dd'),2),'yyyy-mm-dd') from dual; 2000-02-01 select to_char(add_months(to_date('1999-12-01','yyyy-mm-dd'),-2),'yyyy-mm-dd') from dual; 1999-10-01