SECSTODATE Function

Purpose

Converts a number of seconds to a date/time pattern string.

Syntax

SECSTODATE (d, p, w)

Parameters

d is a string for the number of seconds in Lilian format. The value for d must have a computational type and is converted to FLOAT BINARY(53) if necessary.

p is a supported date/time pattern. If not specified, SECSTODATE uses the value YYYYMMDDHHMISS9999, which is the same format returned by DATETIME.

w specifies an expression (such as 1976) that can be converted to an integer.

Negative values are treated as an offset and subtracted from the current, system-supplied year.
If not specified, the value of w is the value specified in the -window compiler option.

Description

Returns a non-varying character string containing the date in a pattern p that corresponds to d seconds in Lilian format.

See the help topic Date/Time Built-in Functions for more information about Lilian format and supported date/time patterns.

Restrictions

None.