MSCEWI3060

The default value for SYSDATE is CURRENT_TIMESTAMP. The column was transformed to timestamp to preserve information.

Severity

Low

Description

This is EWI added when the default value for SYSDATE is changed from CURRENT_DATE to CURRENT_TIMESTAMP.

Example Code

Input Code:

CREATE TABLE T1
(
    COL1 DATE
)

Output Code:

CREATE TABLE T1
(
   COL1 TIMESTAMP /*** MSC-WARNING - MSCEWI3060 - DEFAULT VALUE FOR SYSDATE IS CURRENT_TIMESTAMP. COLUMN WAS TRANSFORMED TO TIMESTAMP TO PRESERVE INFORMATION. ***/
)

Recommendations