MSCEWI2058

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

triangle-exclamation

Severity

Low

Description

Teradata allows specifying any time zone offset between -12:59 and +14:00 when using the SET TIME ZONE query, however, Snowflake only supports time zones from the IANA Time Zone Databasearrow-up-right.

When the specified offset used in the SET TIME ZONE does not correspond to a IANA standard time zone the offset will be rounded to the standard time zone with the nearest offset and this warning will be generated.

Example Code

Input Code:

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

Output Code:

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

Recommendations

Last updated