FunctionEPOCHTOJSON
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.

See https://www.epochconverter.com/

For more examples, see Datetime handling.