MSCEWI2058
Non-standard time zone offsets are not supported in Snowflake, rounded to nearest valid time zone
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
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 Database.
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
No additional user actions are required.
If you need more support, you can email us at [email protected]
Last updated