DateFromUnixMs

The DateFromUnixMs function converts a Unix timestamp in milliseconds to the date data type in ISO date time format.

📘

The UNIX timestamp is the number of seconds elapsed since an absolute point in time, midnight of Jan 1, 1970 in UTC time. This is also known as the Unix epoch, and represents an absolute time.

Syntax

DateFromUnixMs(milliseconds)

Function arguments:

milliseconds (required) The number of milliseconds since 1970-01-01 00:00:00 UTC.

Notes

• If milliseconds is Null, the function returns Null.
• If your data is in seconds or microseconds, you can use the DateFromUnix or DateFromUnixUs functions.

Examples

DateFromUnixMs(0)

• Returns 1970-01-01 00:00:00.

DateFromUnixMs(1503724894000)

• Returns 2017-08-26 05:21:34.

DateFromUnixMs(-100000000000)

• Returns 1966-10-31 06:13:20.