SSC-FDM-0005

TIME ZONE not supported for time data type

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 information, go here.

Example Code

Input Code:

IN -> Teradata_01.sql
CREATE TABLE TABLE_TIME_TYPE (
    COLNAME TIME (9) WITH TIME ZONE
);

Output Code:

OUT -> Teradata_01.sql
CREATE OR REPLACE TABLE TABLE_TIME_TYPE (
    COLNAME TIME(9) /*** SSC-FDM-0005 - TIME ZONE NOT SUPPORTED FOR TIME DATA TYPE ***/
)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}'
;

Recommendations

Last updated