Skip to main content

1E 9.x (on-premises)

EPOCHTOJSON

Function

EPOCHTOJSON

Action

Takes a date-time value, expressed as a Unix epoch time in UTC, and returns a JSON-compatible (ISO-8601) string representation of that date-time, also in UTC.

Parameters

(integer) Unix epoch time in numeric form.

Return values

(string) The time as an ISO-8601 string.

Examples

// Input is 1492761464 == 21 April 2017 07:57:44 UTC
// Returns "2017-04-21T07:57:44.000Z"
SELECT EPOCHTOJSON(1492761464) AS MyDateTime;

Notes

This function is useful as all date-times returned by the Tachyon Agent must be in ISO-8601 format to be parsed correctly by the Tachyon Server.

Seehttps://www.epochconverter.com/

For more examples, see Datetime handling.