_add_minutes

Returns the time or datetime, depending on the format of "time_expression", that results from adding "integer_expression" minutes to "time_expression".

Syntax

_add_minutes ( time_expression, integer_expression )

Example 1

_add_minutes ( 13:59:00 , 1 )

Result

14:00:00

Example 2

_add_minutes ( 2002-04-30 12:59:10.000, 1 )

Result

2002-04-30 13:00:10.000

Example 3

_add_minutes ( 2002-04-30 00:00:00.000, 1/60 )
Note that the second 
argument is not a whole number. This is supported by some database 
technologies and increments the time portion.

Result

2002-04-30 00:00:01.000