%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 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 in *ISO format.

For an example of date and time arithmetic operations, see Figure 232.

For more information, see Date Operations or Built-in Functions.



[ Top of Page | Previous Page | Next Page | Contents | Index ]