unixtime_milliseconds_todatetime()

Converts unix-epoch milliseconds to UTC datetime.

Syntax

unixtime_milliseconds_todatetime(*milliseconds*)

Arguments

• milliseconds: A real number represents epoch timestamp in milliseconds. Datetime 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 will be a datetime value. If conversion is not successful, result will be null.

See also

• 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().

Example

print date_time = unixtime_milliseconds_todatetime(1546300800000)

date_time
2019-01-01 00:00:00.0000000