Comment on page
MSCEWI1044
Type changed to Date.
Low
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.
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
);
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
);
- No additional user actions are required.