add_months(date date or timestamp, int month)

Let us now check the add_months(date,month) function with the following query.

Query

default> select add_months(date '2016-08-11',1) as months;  

Result

The above query will generate the following result.

months 
------------------------------- 
2016-09-11 00:00:00

Here, one month is added from the given date.