SECSTODATE

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 2. For an explanation of Lilian format, see Date/time built-in functions.