Categories: Date/Time, Conversion

TO_UTC_TIMESTAMP

Converts a timestamp from the specified timezone to UTC.

Syntax

TO_UTC_TIMESTAMP(timestamp timestamp, sourceTimezone varchar) → timestamp

• timestamp: The timestamp in the source timezone to convert to UTC.
• sourceTimezone: The timezone to convert from.

Examples

TO_UTC_TIMESTAMP example

SELECT TO_UTC_TIMESTAMP(TIMESTAMP '2026-03-18 14:30:45.123456789', 'America/Los_Angeles')
-- 2026-03-18 21:30:45.123456789

TO_UTC_TIMESTAMP example

SELECT TO_UTC_TIMESTAMP('2021-04-01 11:27:32', 'EDT')
-- 2021-04-01 15:27:32.000

TO_UTC_TIMESTAMP example

SELECT TO_UTC_TIMESTAMP(NULL, 'America/Los_Angeles')
-- null