SELECT ADD_MONTHS( TO_DATE( '2005-07-26', 'yyyy-MM-dd' ), 12) FROM dual
结果:'2006-07-26'
SELECT ADD_MONTHS( TO_DATE( '2005-07-26', 'yyyy-MM-dd' ), -12) FROM dual
结果:'2004-07-26'
SELECT ADD_MONTHS( TO_DATE( '2005-07-26', 'yyyy-MM-dd' ), 12) FROM dual
结果:'2006-07-26'
SELECT ADD_MONTHS( TO_DATE( '2005-07-26', 'yyyy-MM-dd' ), -12) FROM dual
结果:'2004-07-26'