ADD_SECOND( )
Adds a specified number of seconds to a date value.
Syntax
ADD_SECOND(date, secondsToAdd)
Arguments
date
The date or date expression representing the start date. If a start date does not have a time value, the function assumes the time is midnight, 12:00 AM.
secondsToAdd
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 data field:
ADD_SECOND([StartTime], 30)