SSC-FDM-TD0005

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

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]