Oracle ADD_MONTHS Function

https://www.databasestar.com/oracle-add_months/
The Oracle ADD_MONTHS allows you to add a specified number of months to a date value, and return the new date value. It’s great for performing calculations on dates, or date arithmetic, which can be hard in many different programming languages.

The syntax of the ADD_MONTHS function is:

ADD_MONTHS ( input_date, number_months )

The function returns a DATE value.

The parameters of this function are:

- input_date (mandatory): This is the starting date, or the date that you will add a number of months to.
- number_months (mandatory): This is an integer value that represents the number of months to add to input_date.

The input_date can be any datetime value, or even a character value that can be converted to a date. Also, the number_months can be any number value, or a character value that can be converted to a number.

What if the number of days in the two months are different? For example, adding a month to Jan 31 could result in Feb 31, which does not exist. Well, in this case, Oracle would work out that the date does not exist, and use the last date of the month (e.g. Feb 28).

You can also provide a negative value for ADD_MONTHS to subtract months from the specified date.

For more information about the Oracle ADD_MONTHS function, including all of the SQL shown in this video and the examples, read the related article here:
https://www.databasestar.com/oracle-add_months/