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

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