DAYSTODATE returns a nonvarying character string containing the
date in the form p that corresponds to d days
(in Lilian format).
 >>-DAYSTODATE--(-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 50. For
an explanation of Lilian format, see Date/time built-in functions.
See DAYS for an example using DAYSTODATE.
|
This information center is powered by Eclipse technology. (http://www.eclipse.org)