MSCEWI1096

TIME ZONE not supported for time data type

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.
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.
​

MSCEWI1095

MSCEWI1097

Last modified 2mo ago