How to Convert UTC to Local Time Zone in Snowflake

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

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.