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.
Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Converts unix-epoch seconds to UTC datetime.
Syntax
unixtime_seconds_todatetime(seconds)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| seconds | real |
✔️ | The epoch timestamp in seconds. 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_seconds_todatetime(1546300800)
Output
| date_time |
|---|
| 2019-01-01 00:00:00.0000000 |
Related content
- Convert unix-epoch milliseconds to UTC datetime using unixtime_milliseconds_todatetime().
- Convert unix-epoch microseconds to UTC datetime using unixtime_microseconds_todatetime().
- Convert unix-epoch nanoseconds to UTC datetime using unixtime_nanoseconds_todatetime().