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

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