Table of Contents

, ,

TIME_ADD

Description

Returns the timestamp resulting from adding/subtracting the specified number of hours to the specified timestamp

Syntax

TIME_ADD (timestamp, hours)

Parameters

An expression producing timestamp and an expression producing a number to be added or subtracted (if the number is negative) to the timestamp

Returns

Timestamp: the timestamp with the given number of hours added (subtracted if negative).

Example

IF TIME_ADD (Account.OpeningTime, 4) = 07/04/2004 12:00 THEN ... 

DATE_ADD, MONTH_ADD, TIMESTAMP, CURRENT_TIMESTAMP