Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference ADDMINUTES
Functions and Expressions Reference Guide
64
ADDMINUTES
The ADDMINUTES function returns a time value that is the result of adding a
specified number of minutes to a given time.
Syntax
ADDMINUTES (single-datetime-item-expression, minutes-
expressed-as-signed-integer-expression)
Meaning
ADDMINUTES (any_datetime, number_of_minutes_to_add)
Returns
This function returns a single-datetime item.
Returns a single-datetime item, advanced from the original value of the single-
datetime-item-expression by the specified number of minutes-expressed-as-
integer-expression.
Examples
ADDMINUTES("Dec 31, 1999 23:59:00", 2) = "Jan 1, 2000
00:01:00"
ADDMINUTES("Dec 31, 1999 23:59:00", -25) = "Dec 31, 1999
23:34:00"
ADDMINUTES("23:59:00", 2) = "00:01:00"
If either argument is invalid, the result is NONE. If the second argument is
NONE, the result is the first argument. If the first argument contains only a
time portion, date changes are ignored. If the first argument contains only a
date portion, the time portion 00:00:00 will be used in the calculation. If both
arguments are NONE, the result is NONE.
Related Functions
DATETONUMBER, NUMBERTODATE, TEXTTODATE, TODATETIME