%SECONDS (Number of Seconds)
%SECONDS(number)
%SECONDS converts a number into a duration that can be added to a time or timestamp value.
%SECONDS can only follow the plus or minus sign in an addition or subtraction expression. The value before the plus or minus sign 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 in *ISO format.
If you are adding or subtracting %SECONDS from a timestamp
value, the parameter can have decimal places
specifying the number of fractional seconds to add or subtract.
For example, the following example adds 5.72 seconds to the timestamp.
timestamp2 = timestamp1 + %SECONDS(5.72);
For an example of date and time arithmetic operations, see Figure 1.
For more information, see Date Operations or Built-in Functions.