SSC-FDM-TD0005

Non-standard time zone offsets are not supported in Snowflake, rounded to nearest valid time zone

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Description

While Teradata provides the flexibility to define any time zone offset between -12:59 and +14:00 using the SET TIME ZONE query, Snowflake exclusively supports time zones listed in the IANA Time Zone Database.

If the specified offset in the SET TIME ZONE query does not align with an IANA standard time zone, Snowflake will automatically round it to the nearest standard time zone with the closest offset. In such a case, a warning message will be generated.

Example Code

Input Code:

IN -> Teradata_01.sql

-- Will be rounded to Asia/Colombo (+05:30)
SET TIME ZONE '05:26';

Output Code:

OUT -> Teradata_01.sql

-- Will be rounded to Asia/Colombo (+05:30)
--** SSC-FDM-TD0005 - NON-STANDARD TIME ZONE OFFSETS NOT SUPPORTED IN SNOWFLAKE, ROUNDED TO NEAREST VALID TIME ZONE **
ALTER SESSION SET TIMEZONE = 'Asia/Colombo';

Recommendations

• No additional user actions are required.

• If you need more support, you can email us at [email protected]