Get started
Load & manage data
Work with data
Administration
Reference & resources
Updated Sep 22, 2023
Send us feedback
to_utc_timestamp
Applies to: Databricks SQL Databricks Runtime
Returns the timestamp in expr in a different timezone as UTC.
expr
to_utc_timestamp(expr, timezone)
expr: A TIMESTAMP expression.
timezone: A STRING expression that is a valid timezone.
timezone
A TIMESTAMP.
> SELECT to_utc_timestamp('2016-08-31', 'Asia/Seoul'); 2016-08-30 15:00:00 > SELECT to_utc_timestamp( '2017-07-14 02:40:00.0', 'GMT+1'); 2017-07-14 01:40:00.0
from_utc_timestamp function