Links

MSCEWI2011

Time Zone not supported for time data type.
This EWI is deprecated, for more information on this issue referred to MSCEWI1096

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.