Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Converts unix-epoch nanoseconds to UTC datetime.
unixtime_nanoseconds_todatetime(nanoseconds)
Learn more about syntax conventions.
| 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. |
If the conversion is successful, the result is a datetime value. Otherwise, the result is null.
print date_time = unixtime_nanoseconds_todatetime(1546300800000000000)
Output
| date_time |
|---|
| 2019-01-01 00:00:00.0000000 |
- Convert unix-epoch seconds to UTC datetime using unixtime_seconds_todatetime().
- Convert unix-epoch milliseconds to UTC datetime using unixtime_milliseconds_todatetime().
- Convert unix-epoch microseconds to UTC datetime using unixtime_microseconds_todatetime().