addMinutes

Returns a modified date after the specified minutes have been added.

Example

Add 10 minutes to the date December 24, 2001 11:55:12 pm.

addMinutes(timestamp("2001-12-24 23:55:12.000"), 10)

This example returns December 25, 2001 00:05:12 pm.

Syntax

addMinutes(timestamp expr t, int min)

Parameters

• t : expression evaluating to timestamp
• min : number of minutes to add as a long

Returns

timestamp

Description

addMinutes adds min minutes to the specified timestamp expression, t and returns the modified date as the result. The number of milliseconds can be positive or negative.