ADD_SECOND( )
Adds a specified number of seconds to a date value.
Syntax
ADD_SECOND(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 seconds 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 seconds to the start date.
Example
The following example adds 30 seconds to each date value in the StartTime field:
ADD_SECOND([StartTime], 30)

Additional Links:

Copyright Actuate Corporation 2012