oracle中add_months()函数及用法总结

SQL> select add_months(sysdate,2) from dual; 
 ADD_MONTHS(SYSDATE,+2)
----------------------
2012-5-16 下午 02:30:47

SQL> select add_months(sysdate,-2) from dual;
ADD_MONTHS(SYSDATE,-2)
----------------------
2011-11-16 下午 02:32:39

select * from tb_user where create_date_time>to_date（'20190101','yyyymmdd'）and create_date_time<tadd_months(to_date（'20190101','yyyymmdd'）,2)

select add_months(sysdate,-1) from dual;

select add_months(sysdate,1) from dual;

select Ename from Company where sysdate >add_months(time,2*12);