Home  >  Blog  >   Snowflake  > 

How to Convert UTC to Local Time Zone in Snowflake

When we work with the timestamps, the Snowflake stores the time zone data by adding the offset in the end of timestamp. The default time zone of Snowflake is PDT timestamp. In this blog, we will discuss changing the PDT timestamp to the local time zone or UTC.

Rating: 4.2
  1. Share:
Snowflake Articles

Convert PDT to UTC or Local Time Zone in the Snowflake

While storing the timestamps, the Snowflake saves time zone data by inserting an offset at the end of the timestamp. The offset code enables the time zone of the timestamps. Snowflake utilises host server as the base for creating output of the “current_timestamp().”

For converting the PDT timestamp to the local time zone or UTC, we can utilise the below code:

current_timestamp() as pdt_time_zone,
convert_timezone(‘UTC’ , current_timestamp()) as utc_time_zone,
convert_timezone (‘New York/London’, current_timestamp()) as New York_London_time_zone

 MindMajix YouTube Channel


This blog helps you learn to convert the PDT timestamp to the local time zone or UTC. It includes the code required for the conversion.

Snowflake Related Articles

▶  Snowflake vs Redshift
▶  Snowflake vs BigQuery
▶  Snowflake vs Databricks
▶  Snowflake vs Azure
▶  Snowflake vs Hadoop
▶  Snowflake Time Travel

If you have any queries, let us know by commenting below.

Join our newsletter

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
Snowflake TrainingNov 08 to Nov 23
Snowflake TrainingNov 12 to Nov 27
Snowflake TrainingNov 15 to Nov 30
Snowflake TrainingNov 19 to Dec 04
Last updated: 06 November 2022
About Author
Keerthi Sai

Keerthi Sai is a Senior Writer at Mindmajix with tons of content creation experience in the areas of cloud computing, BI, Perl Scripting. She also creates content on Salesforce, Microstrategy, and Cobit.