SSC-FDM-0005

TIME ZONE not supported for time data type

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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

• No end-user action is required.

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