Comment on page
MSCEWI1096
TIME ZONE not supported for time data type
Medium
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
CREATE TABLE TABLE_TIME_TYPE(
COLNAME TIME (9) WITH TIME ZONE,
);
CREATE TABLE TABLE_TIME_TYPE(
COLNAME TIME (9)
-- ** MSC-ERROR - MSCEWI1094 - TIME ZONE NOT SUPPORTED FOR TIME DATA TYPE **
-- WITH TIME ZONE
);
- No end-user action is required.