Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference ADDHOURS
Functions and Expressions Reference Guide
62
ADDHOURS
The ADDHOURS function returns a time value that is the result of adding a specified
number of hours to a given time.
Syntax
ADDHOURS (single-datetime-item-expression, hours-expressed-
as-signed-integer-expression)
Meaning
ADDHOURS (any_datetime, number_of_hours_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 hours-expressed-as-
integer-expression.
Examples
ADDHOURS(TODATETIME("Dec 31, 1999 23:59:00"), 2)
returns Jan 1, 2000 01:59:00.
ADDHOURS(TODATETIME("Dec 31, 1999 23:59:00"), -25)
returns Dec 30, 1999 22:59:00.
ADDHOURS(TODATETIME("23:59:00", 2)
returns 01:59: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.