DAYSTODATE
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/time patterns.
If omitted, p is assumed to be the default date/time pattern 'YYYYMMDDHHMISS999' (same as the default format returned by DATETIME).
- 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.
The allowed patterns are listed in Table 2. For an explanation of the Lilian format, see Date/time built-in functions.
See DAYS for an example of using DAYSTODATE.