Skip to main content

CONVERT_TIMEZONE function

Converts a timestamp from one time zone to another.

Syntax

CONVERT_TIMEZONE(timestamp, source_timezone, target_timezone)

Arguments

  • source_timezone: The time zone of the input timestamp (optional). If omitted, the timestamp is assumed to be in UTC.

  • target_timezone: The time zone to convert to.

  • timestamp: A TIMESTAMP value.

Returns

A TIMESTAMP representing the input time in the target time zone.

Supported Time Zone Formats

  • Named time zones: 'America/New_York', 'Europe/London', 'Asia/Tokyo'

  • Abbreviations: 'UTC', 'EST', 'PST', 'CET'

  • UTC offsets: '+05:00', '-08:00'

Examples

-- Example 1: Convert between two time zones
> SELECT CONVERT_TIMEZONE(TIMESTAMP '2025-01-15 12:00:00', 'America/Los_Angeles', 'Europe/London');
2025-01-15 20:00:00

-- Example 2: Convert from EST to UTC
> SELECT CONVERT_TIMEZONE(TIMESTAMP '2025-01-15 12:00:00', 'EST', 'UTC');
2025-01-15 17:00:00

-- Example 3: Using UTC offset notation
> SELECT CONVERT_TIMEZONE(TIMESTAMP '2025-01-15 12:00:00', '+00:00', '-05:00');
2025-01-15 07:00:00

See Also