DateFromUnixUs

The DateFromUnixUs function converts a Unix timestamp in microseconds 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

DateFromUnixUs(microseconds)

Function arguments:

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

Notes

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

Examples

DateFromUnixUs(0)

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

DateFromUnixUs(1503724894000000)

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

DateFromUnixUs(-100000000000000)

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