Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

FunctionEPOCHTOJSON
Action


Excerpt
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


Code Block
languageperl
// Input is 1492761464 == 21 April 2017 07:57:44 GMTUTC
// 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.

...