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.

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.

Job Support Program

Online Work Support for your on-job roles.

jobservice

Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:

  • Pay Per Hour
  • Pay Per Week
  • Monthly
Learn MoreGet Job Support
Course Schedule
NameDates
Snowflake TrainingDec 07 to Dec 22View Details
Snowflake TrainingDec 10 to Dec 25View Details
Snowflake TrainingDec 14 to Dec 29View Details
Snowflake TrainingDec 17 to Jan 01View Details
Last updated: 04 Apr 2023
About Author

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.

read less
  1. Share:
Snowflake Articles