MSCEWI3060
The default value for SYSDATE is CURRENT_TIMESTAMP. The column was transformed to timestamp to preserve information.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
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
No end-user actions are required.
If you need more support, you can email us at [email protected]
Last updated