DAYSTODATE returns a nonvarying character string containing the date in the form p that corresponds to d days
(in Lilian format).
- d
- The number of days (in Lilian format).
d must have a computational type and is converted to
FIXED BINARY(31,0) if necessary.
- p
- One of the supported date patterns shown in Table 35.
If omitted, the compiler assumes that p is the default
pattern returned by the DATETIME built-in function (YYYYMMDDHHMISS999).
p should have character type. If not, it is converted
to character.
- w
- An integer expression that defines a century window to be
used to handle any two-digit year formats.
- If the value is positive, such as 1950, it is treated as a year.
- If negative or zero, the value specifies an offset to be subtracted
from the current, system-supplied year.
- If omitted, w defaults to the value specified in the
WINDOW compile-time option.