ADD_MINUTE( )
Adds a specified number of minutes to a date value.
Syntax
ADD_MINUTE(date, minutesToAdd)
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.
minutesToAdd
The number of minutes to add to the start date. If you specify a negative number, the result appears to subtract the number from the start date.
Returns
The date-and-time value that results from adding the specified number of minutes to the start date.
Example
The following example subtracts 30 minutes from each date in the StartTime data field:
ADD_MINUTE([StartTime], -30)

Additional Links:

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2