UNIXDT

Purpose:

Converts Unix seconds to a datetime series.

Syntax:

UNITXDT(ut, offset, "date")

(d, t) = UNIXDT(ut, offset, "date")

ut

-

A series of Unix time values.

offset

-

Optional. A real, the time offset. Defaults to 0.0.

"date"

-

Optional. A string, the starting date in dd/mm/yy format. Defaults to "1/01/1970".

Returns:

A datetime series where the data and time values are in two adjacent columns.

 

(d, t) = UNIXDT(ut, offset, "date") returns the Julian dates and time of day seconds in to separate variables.

Example:

W1: {1407159000, 1408159082, 1411150163, 1417159180, 1427159240}

W2: unixdt(W1)

 

W2 contains the datetime series:

 

 8/04/2014   13:30:00

 8/16/2014    3:18:02

 9/19/2014   18:09:23

11/28/2014    7:19:40

 3/24/2015    1:07:20

Example:

W3: {1407159000, 1408159082, 1411150163, 1417159180, 1427159240}

W4: (d, t) = unixdt(W3); ravel(d, t)

 

W4 contains the datetime series:

 

 8/04/2014   13:30:00

 8/16/2014    3:18:02

 9/19/2014   18:09:23

11/28/2014    7:19:40

 3/24/2015    1:07:20

Remarks:

Unix time values are generally in seconds elapsed since 1/01/1970. UNIXDT converts the second values into Julian days and clock time for the day.

 

A datetime series consists of 2 columns of values where the first column contains integer Julian dates starting at midnight and the second column contains time in seconds starting from midnight.

 

UNIXDT is the same as UNIX2DT and provided for backwards compatibility. UNIX2DT is preferred.

See Also:

DECDATE

DECTIME

DTXY

JULYMD

STRJUL

STRTOD

TODSTR

UNIX2DT

XYDT