MILLIS_TO_TIMESTAMP

Returns a representation of the unixEpoch argument (milliseconds since Unix Epoch started on 1970-01-01 at 00:00:00) as a timestamp in UTC.

This function returns the same result as TO_TIMESTAMP but its name is perhaps easier to recall.

Syntax

MILLIS_TO_TIMESTAMP(unixEpoch)

Returns NULL if unixEpoch is NULL.

Example

values millis_to_timestamp(1234567890123);
'EXPR$0'
'2009-02-13 23:31:30.123'