%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.