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