unixtime_milliseconds_todatetime

The unixtime_milliseconds_todatetime function converts the input into a datetime value (Unix time in seconds).

To convert datetime (Unix time) into a string, or vice versa, use the strftime and strptime functions.

Syntax

​

unixtime_milliseconds_todatetime( Milliseconds )

Arguments

​

• Milliseconds: An epoch timestamp in milliseconds. Time that occurs before the Unix epoch (1970-01-01 00:00:00) has a negative timestamp value.

Returns

​

If the conversion is successful, the result will be a datetime value (Unix time in seconds). Otherwise, the result will be null.

Example

​

unixtime_milliseconds_todatetime(1546300800000) returns as 1546300800