%DAYS (Number of Days)


%DAYS converts a number into a duration that can be added to a date or timestamp value.

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

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

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