ADD_DAYS
Description
ADD_DAYS adds a given number of days to a given date.
Supported input column types: base_column -> DATE, days_column -> INT
Output column type: DATE
If a result of type DATE is outside the interval from the year 1400 CE (including) to the year 10000 CE (excluding), it will be mapped to NULL.
Syntax
ADD_DAYS ( table.base_column, table.days_column )
NULL handling
If any parameter is NULL, the result is NULL as well.
Example
[1] Simple example for ADD_DAYS. | ||||||||||||||||
| ||||||||||||||||
|