UTC_TO_TIMESTAMP

The UTC_TO_TIMESTAMP function takes a decimal or integer number—which specifies the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC), Thursday, 1 January 1970—and converts it into a timestamp. Leap seconds are not counted.

The result from this function is automatically offset by the number of hours from GMT+0 of the timezone where this TDV instance resides.

Syntax

UTC_TO_TIMESTAMP (expression)

Remarks

•

The expression is a DECIMAL or INTEGER specifying the number of seconds since 00:00:00 UTC.

•

If the input is NULL, the result is NULL.

•

The argument must not be less than ‑9223372036854775 or exceed 9223372036854775; otherwise, an exception occurs.

Example

UTC_TO_TIMESTAMP (36000) 

This example returns a timestamp of 1970-01-01 10:00:00 if TDV Server is in time zone GMT+0, but a timestamp of 1970-01-01 02:00:00 if the TDV Server is in the America/Los_Angeles time zone (GMT-8).