MSCEWI1044

Type changed to Date.

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

Severity

Low

Description

This message is shown when SnowConvert finds a DEFAULT SYSDATE and the data type is NOT a DATE or TIMESTAMP datatype. In this case, the data type is changed to DATE.

Code Example

Input Code:

CREATE TABLE "SYSDATE_DEFAULT_TEST_TABLE_1"( 
 "COLUMN1" NUMBER(16,0),
 "COLUMN2" VARCHAR2(30 BYTE) DEFAULT SYSDATE,
 "COLUMN3" TIMESTAMP WITH LOCAL TIME ZONE DEFAULT SYSDATE
);

Output Code:

CREATE OR REPLACE TABLE PUBLIC.SYSDATE_DEFAULT_TEST_TABLE_1 ( 
 COLUMN1 NUMBER (16,0),
 COLUMN2 DATE DEFAULT CURRENT_DATE /*** MSC-WARNING - MSCEWI1044 - CONVERTED FROM VARCHAR2 TO DATE FOR CURRENT_DATE DEFAULT ***/,
 COLUMN3 TIMESTAMP_LTZ DEFAULT CURRENT_DATE
);

Recommendations

• No additional user actions are required.

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