SSC-FDM-TD0005
Non-standard time zone offsets are not supported in Snowflake, rounded to nearest valid time zone
Last updated
Non-standard time zone offsets are not supported in Snowflake, rounded to nearest valid time zone
Last updated
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 .
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.
No additional user actions are required.
If you need more support, you can email us at