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
SELECT ADD_DAYS(DATE '2000-02-28', 1) AD1,
ADD_DAYS(TIMESTAMP '2001-02-28 12:00:00', 1) AD2;
Result
AD1 | AD2 |
2000-02-29 | 2001-03-01 12:00:00.000000 |