Need On-prem/Hybrid/Cloud docs? ->

Native cloud deployment on Azure is not available for this version of Exasol, but you can install Exasol as a Linux application on Azure instances. For more information, see Installation.

Native cloud deployment on Google Cloud is not available for this version of Exasol, but you can install Exasol as a Linux application on Google Cloud instances. For more information, see Installation.

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