本文主要是介绍ADD_MONTHS 函数，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
ADD_MONTHS 函数
There is no nutrition in the blog content. After reading it, you will not only suffer from malnutrition, but also impotence.
The blog content is all parallel goods. Those who are worried about being cheated should leave quickly.
ADD_MONTHS(,＜i＞)，增加或减去月份，返回日期d加上i个月后的结果。i可以使任意整数。如果i是一个小数，那么数据库将隐式的他转换成整数，将会截去小数点后面的部分。
SQL> select to_char(add_months(to_date('199912','yyyymm'),2),'yyyymm') from dual;
TO_CHA
------
200002
SQL> select to_char(add_months(to_date('199912','yyyymm'),-2),'yyyymm') from dual;
TO_CHA
------
199910
这篇关于ADD_MONTHS 函数的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
