unixtime_nanoseconds_todatetime()

Applies to: ✅ Microsoft FabricAzure Data ExplorerAzure MonitorMicrosoft Sentinel

Converts unix-epoch nanoseconds to UTC datetime.

Syntax

unixtime_nanoseconds_todatetime(nanoseconds)

Learn more about syntax conventions.

Parameters

Name Type Required Description
nanoseconds real ✔️ The epoch timestamp in nanoseconds. A datetime value that occurs before the epoch time (1970-01-01 00:00:00) has a negative timestamp value.

Returns

If the conversion is successful, the result is a datetime value. Otherwise, the result is null.

Example

print date_time = unixtime_nanoseconds_todatetime(1546300800000000000)

Output

date_time
2019-01-01 00:00:00.0000000