ADD_HOUR( )

Adds a specified number of hours to a date value.

Syntax

ADD_HOUR(date, n)

Arguments

date

The date or date expression that represents the start date. If a start date does not have a time value, the function assumes the time is midnight, 12:00 AM.

n

The number of hours to add to the start date. If you specify a negative number, the result is as if the number is subtracted from the start date.

Returns

The date-and-time value that results from adding the specified number of hours to the start date.

Example

The following example adds eight hours to each date value in the ShipDate field:

ADD_HOUR([ShipDate], 8)

Copyright Actuate Corporation 2012