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