CONVERT_TIMEZONE

Description

The CONVERT_TIMEZONE function in Amazon Redshift converts a timestamp from one time zone to another, where you specify the original time zone, the target time zone, and the timestamp to convert. Making it useful for managing time accurately across different regions

Grammar Syntax

CONVERT_TIMEZONE(source_timezone, target_timezone, timestamp)

Sample Source Patterns

Input Code:

Redshift

IN -> Redshift_01.sql

SELECT
    GETDATE(),
    CONVERT_TIMEZONE('UTC', 'Europe/London', GETDATE()) AS london_time,
    CONVERT_TIMEZONE('UTC', 'Asia/Tokyo', GETDATE()) AS tokyo_time;

Results

getdate	london_time	tokyo_time
2024-10-02 16:14:55.000000	2024-10-02 17:14:55.000000	2024-10-03 01:14:55.000000

Output Code:

Snowflake

OUT -> Redshift_01.sql

SELECT
    GETDATE(),
    CONVERT_TIMEZONE('UTC', 'Europe/London', GETDATE()) AS london_time,
    CONVERT_TIMEZONE('UTC', 'Asia/Tokyo', GETDATE()) AS tokyo_time;

Results

getdate	london_time	tokyo_time
2024-10-02 09:18:43.848	2024-10-02 10:17:35.351	2024-10-02 18:17:35.351

Related EWIs

There are no known issues.