DAYSTODATE

DAYSTODATE returns a nonvarying character string containing the date in the form p that corresponds to d days (in Lilian format).

Read syntax diagramSkip visual syntax diagramDAYSTODATE(d, p, w)
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.