Links

MSCEWI1044

Type changed to Date.

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.
  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs