How to Convert UTC to Local Time Zone in Snowflake
When storing timestamps, Snowflake stores time zone data in the form of adding the offset at the end of the timestamp. That offset code tells us the time zone of timestamps.
Snowflake uses the host server time as the basis for generating the output of current_timestamp()
.
Default timezone in Snowflake is Pacific Daylight Time (PDT). To convert a PDT timestamp to a UTC or a local time zone, you can use the following:
select
current_timestamp() as pdt_time_zone,
convert_timezone('UTC', current_timestamp()) as utc_time_zone,
convert_timezone('Europe/Paris', current_timestamp()) as europe_paris_time_zone
Note: Snowflake supports IANA time zone database.
Previous
How to Truncate a Table