MSCEWI1096

TIME ZONE not supported for time data type

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium

Description

The Time data type in Snowflake does not store Timezone values

TIME internally stores “wallclock” time, and all operations on TIME values are performed without taking any time zone into consideration. For more info

Example Code

Input Code:

CREATE TABLE TABLE_TIME_TYPE(
    COLNAME TIME (9) WITH TIME ZONE,
);

Output Code:

CREATE TABLE TABLE_TIME_TYPE(
    COLNAME TIME (9)
-- ** MSC-ERROR - MSCEWI1094 - TIME ZONE NOT SUPPORTED FOR TIME DATA TYPE **
--                      WITH TIME ZONE
);

Recommendations

• No end-user action is required.

• If you need more support, you can email us at [email protected]