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.
Name | Dates | |
---|---|---|
Snowflake Training | Sep 14 to Sep 29 | View Details |
Snowflake Training | Sep 17 to Oct 02 | View Details |
Snowflake Training | Sep 21 to Oct 06 | View Details |
Snowflake Training | Sep 24 to Oct 09 | View Details |
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.