ADD_DAYS

Purpose

This function adds a specified number of days to a date or timestamp.

Syntax

add_days::=

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

Copy

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