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||Mar 25 to Apr 09|
|Snowflake Training||Mar 28 to Apr 12|
|Snowflake Training||Apr 01 to Apr 16|
|Snowflake Training||Apr 04 to Apr 19|
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 - 2023 MindMajix Technologies