Spark SQL - Conversion between UTC and Timestamp with Time Zone

In Spark SQL, function from_utc_timestamp(timestamp, timezone) converts UTC timestamp to a timestamp in the given time zone; function to_utc_timestamp(timestamp, timezone) converts timestamp in a given time zone to UTC timestamp.

Code snippets

The following are some examples to convert UTC to the time with time zone information and vice versa.

spark-sql> select from_utc_timestamp('2022-06-04 21:34:29.538','Australia/Melbourne');
from_utc_timestamp(CAST(2022-06-04 21:34:29.538 AS TIMESTAMP), Australia/Melbourne)
2022-06-05 07:34:29.538

spark-sql> select to_utc_timestamp('2022-06-04 21:34:29.538','UTC+10');
to_utc_timestamp(CAST(2022-06-04 21:34:29.538 AS TIMESTAMP), UTC+10)
2022-06-04 11:34:29.538

spark-sql> select to_utc_timestamp('2022-06-04 21:34:29.538','Australia/Melbourne');
to_utc_timestamp(CAST(2022-06-04 21:34:29.538 AS TIMESTAMP), Australia/Melbourne)
2022-06-04 11:34:29.538

Time zone ID list

List of tz database time zones - Wikipedia

You can also use GMT and UTC timezone string, for example, 'GMT+1', 'UTC+10', etc.