unixtime_milliseconds_todatetime()
Learn how to use the unixtime_milliseconds_todatetime() function to convert unix-epoch milliseconds to UTC datetime.
Converts unix-epoch milliseconds to UTC datetime.
Syntax
unixtime_milliseconds_todatetime(milliseconds)
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| milliseconds | real | ✔️ | The epoch timestamp in microseconds. 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_milliseconds_todatetime(1546300800000)
Output
| date_time |
|---|
| 2019-01-01 00:00:00.0000000 |
Related content
- Convert unix-epoch seconds to UTC datetime using unixtime_seconds_todatetime().
- Convert unix-epoch microseconds to UTC datetime using unixtime_microseconds_todatetime().
- Convert unix-epoch nanoseconds to UTC datetime using unixtime_nanoseconds_todatetime().
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.