TO_TIMESTAMP

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Time Functions >

TO_TIMESTAMP

Previous pageReturn to chapter overviewNext page

Returns a representation of the UNIX_TIMESTAMP argument as a value in 'YYYY-MM-DD HH:MM:SS' format. The value is expressed in the current time zone. unix_timestamp is an internal timestamp value such as is produced by the UNIX_TIMESTAMP function.

5_2_indicator

Version 5.3 Feature

This feature is new in s-Server 5.3.

Syntax

TO_TIMESTAMP(unixEpoch)

where unixEpoch is a Unix timestamp (milliseconds since '1970-01-01 00:00:00' UTC) expressed as a BIGINT.

Returns TIMESTAMP

Returns NULL if unixEpoch is null.

Otherwise, returns new java.sql.Timestamp(unixEpoch)

Example

values TO_TIMESTAMP(1649015546614);

'EXPR$0'

'2022-04-03 19:52:26.614'