add_days(date date or timestamp, int day)

Let us now check the add_days(date,day) function with the following query.

Query

default> select add_days(date '2016-08-11',2) as add;

Result

The above query will generate the following result.

add 
------------------------------- 
2016-08-13 00:00:00 

The above query returns the given date by adding two days.

Let us now see how the query progresses further.

Query

default> select add_days(timestamp '2016-08-11 17:04:00',2) as add; 

Result

The above query will generate the following result.

add 
------------------------------- 
2016-08-13 17:04:00 

The query returns the given timestamp by adding two days to it.