Skip to main content

Categories: Date/Time, Conversion

FROM_UTC_TIMESTAMP

Converts a UTC timestamp to the specified timezone.

Syntax​

FROM_UTC_TIMESTAMP(timestamp timestamp, destinationTimezone varchar) → timestamp​

  • timestamp: The UTC timestamp to convert.
  • destinationTimezone: The timezone to convert to.

Examples

FROM_UTC_TIMESTAMP example 
SELECT FROM_UTC_TIMESTAMP(TIMESTAMP '2026-03-18 14:00:00.123456789', 'America/Los_Angeles')
-- 2026-03-18 07:00:00.123456789
SELECT FROM_UTC_TIMESTAMP('2021-04-01 15:27:32', 'EDT')
-- 2021-04-01 11:27:32.000
SELECT FROM_UTC_TIMESTAMP(NULL, 'America/Los_Angeles')
-- null