How to Convert UTC to Local Time Zone in Snowflake

When storing timestamps, Snowflake stores time zone data in the form of adding the offset at the end of the timestamp. That offset code tells us the time zone of timestamps.

Snowflake uses the host server time as the basis for generating the output of current_timestamp().

Default timezone in Snowflake is Pacific Daylight Time (PDT). To convert a PDT timestamp to a UTC or a local time zone, you can use the following:

select
  current_timestamp() as pdt_time_zone,
  convert_timezone('UTC', current_timestamp()) as utc_time_zone,
  convert_timezone('Europe/Paris', current_timestamp()) as europe_paris_time_zone

Note: Snowflake supports IANA time zone database.

database icon
Real-time SQL collaboration is here
Get started with PopSQL and Snowflake in minutes