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_MINUTES

Purpose

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

Syntax

add_minutes::=

Add Minutes

Usage Notes

Decimals are rounded before adding that 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_MINUTES(TIMESTAMP '2000-01-01 00:00:00',-1) AM1,
       ADD_MINUTES(TIMESTAMP '2000-01-01 00:00:00',+2) AM2;

Result

AM1	AM2
1999-12-31 23:59:00.000000	2000-01-01 00:02:00.000000