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.
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
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
If you have any queries, let us know by commenting below.
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
|Snowflake Training||Nov 08 to Nov 23|
|Snowflake Training||Nov 12 to Nov 27|
|Snowflake Training||Nov 15 to Nov 30|
|Snowflake Training||Nov 19 to Dec 04|
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.
Copyright © 2013 - 2022 MindMajix Technologies