📘Introducing SQL Notebooks: Tell stories using data.Read more →

How to Convert UTC to Local Time Zone in Snowflake 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:

  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.

Ready for a modern SQL editor?