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
  
 
238
  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:

select
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

Conclusion

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
inbox

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
NameDates
Snowflake TrainingAug 20 to Sep 04
Snowflake TrainingAug 23 to Sep 07
Snowflake TrainingAug 27 to Sep 11
Snowflake TrainingAug 30 to Sep 14
Last updated: 17 August 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.