ADD_DAYS
Purpose
This function adds a specified number of days to a date or timestamp.
Syntax
add_days::=
Usage Notes
- Decimals are rounded before adding the number.
- For data type TIMESTAMP WITH LOCAL TIME ZONE this function is calculated within the session time zone.
Example
Result
AD1 | AD2 |
2000-02-29 | 2001-03-01 12:00:00.000000 |