ADD_MINUTES
Purpose
This function adds a specified number of minutes to a timestamp.
Syntax
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 |