_add_days

Returns the date or datetime, depending on the format of "date_expression", that results from adding "integer_expression" days to "date_expression".

Syntax

_add_days ( date_expression, integer_expression )

Example 1

_add_days ( 2002-04-30 , 1 )

Result

2002-05-01

Example 2

_add_days ( 2002-04-30 12:10:10.000, 1 )

Result

2002-05-01 12:10:10.000

Example 3

_add_days ( 2002-04-30 00:00:00.000, 1/24 )
Note that the second 
argument is not a whole number. This is supported by some database 
technologies and increments the time portion.

Result

2002-04-30 01:00:00.000