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 MILLIS_TO_TIMESTAMP.

Syntax

TO_TIMESTAMP(unixEpoch)

Returns NULL if unixEpoch is NULL.

Example

values TO_TIMESTAMP(1649015546614);
'EXPR$0'
'2022-04-03 19:52:26.614'