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_HOURS

Purpose

This function adds a specified number of hours to a timestamp.

Syntax

add_hour::=

Add Hour

Usage Notes

Decimals are rounded before adding the number.
For data type TIMESTAMP WITH LOCAL TIME ZONE this function is calculated internally within UTC before the result is transformed to the session time zone.

Example

Copy

SELECT ADD_HOURS(TIMESTAMP '2000-01-01 00:00:00', 1) AH1,
       ADD_HOURS(TIMESTAMP '2000-01-01 12:23:45', -1) AH2;

Result

AH1	AH2
2000-01-01 01:00:00.000000	2000-01-01 11:23:45.000000