Friday, November 15, 2019

How to add month in oracle database

in oracle database you can add month in date used ADD_MONTHS function.

select SYSDATE,ADD_MONTHS(SYSDATE,3) from DUAL;

------------------------------------
15-NOV-19 15-FEB-20

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home