%SECONDS Function

%SECONDS built-in function converts a number into a duration that can be added to a time or timestamp value.

%SECONDS (Number) 
        

Parameters

Number

Required. The number to be converted to duration and added to or subtracted from a time or timestamp value.

Remarks

%SECONDS can only be the right-hand value in an addition or subtraction operation. The left-hand value must be a time or timestamp. The result is a time or timestamp value with the appropriate number of seconds added or subtracted. For a time, the resulting value is *ISO format.

See Also

Built-in Function Overview

Adding or Subtracting Dates

%DAYS

%DIFF

%HOURS

%MINUTES

%MONTHS

%MSECONDS

%YEARS