FROM_UTC_TIMESTAMP

Use the FROM_UTC_TIMESTAMP function to return a timestamp converted from UTC to the selected time zone. The first parameter is the UTC timestamp. The second parameter is the timezone with which to convert from UTC. The result is a timestamp with time zone.

Syntax

FROM_UTC_TIMESTAMP(UTC_timestamp,timezone)

Example

SELECT FROM_UTC_TIMESTAMP('2020-07-13T09:30:00Z','America/New_York')

Result: 2020-07-13T05:30:00.000-04:00