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:

  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
SQL editing that just rocks
PopSQL and Snowflake, better together