SECSTODATE returns a nonvarying character string containing the
date in the date/time pattern specified by p that corresponds
to d seconds (based on Lilian format).
 >>-SECSTODATE-(-d--+-----------+-)-----------------------------><
'-,p-+----+-'
'-,w-'
|
- d
- The number of seconds (in Lilian format). d must have
a computational type and is converted to FLOAT BIN(53)
if necessary.
- p
- One of the supported date/time patterns. If omitted, p is
assumed to be the default date/time pattern 'YYYYMMDDHHMISS999' (the
default format returned by DATETIME).
- w
- Specifies an expression (such as 1950) that can be converted
to an integer. If negative, it specifies an offset to be subtracted
from the value of the year when the code runs. 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.
|
This information center is powered by Eclipse technology. (http://www.eclipse.org)