ADD_SECOND( ) Adds a specified number of seconds to a date value. Syntax ADD_SECOND(date, secondsToAdd) 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. secondsToAdd The number of seconds 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 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)
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy