MSCEWI2011

Time Zone not supported for time data type.

Severity

Low

Description

This message is shown when SnowConvert finds a data type TIME WITH TIME ZONE. This message is added since Snowflake does not support the data type TIME along with WITH TIME ZONE.

Code Example

Input Code:

CREATE TABLE TableExample
(
ColumnExample TIME(0) WITH TIME ZONE
)

Output Code:

CREATE TABLE PUBLIC.TableExample
(
ColumnExample TIME(0) /*** MSC-WARNING - MSCEWI2011 - TIME ZONE NOT SUPPORTED FOR TIME DATA TYPE ***/
);

Note that WITH TIME ZONE is removed from the original data type.

Recommendations

  • No additional user actions are required.

  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.