toDateTimeUnix

toDateTimeUnix() function is the Standard function available in 200OK.

Description : The toDateTime function converts the input Unix timestamp into the specified format.

Syntax : fx_toDateTime(date in unix format,unix)

Example : fx_toDateTime(1510654220787,unix) returns "2017-11-14T10:10:20.787Z", representing the time in Unix format.

Here we go with simple scenario using the above function.

Scenario : For efficient data analysis, users convert Unix timestamps into human-readable format for clear interpretation. This ensures consistency and readability across analyses. For instance, converting Unix timestamp '1510654220787' into 'yyyy-MM-ddTHH:mm:ss.000Z' format yields '2017-11-14T10:10:20.787Z'.

Request Side :

Response Side :