MSCEWI4068

Timestamp format was not found.

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

Severity

Low

Description

This EWI is added when there is an unrecognized date format while casting a date to varchar.

In this case, SnowConvert uses yyyy-mm-dd hh:mm:ss format as default.

Input Code:

SELECT CONVERT(varchar, getdate(), 545495)

Output Code:

SELECT
/*** MSC-WARNING - MSCEWI4068 - TIMESTAMP FORMAT WAS NOT FOUND, CASTED TO yyyy-mm-dd hh:mm:ss FORMAT ***/
TO_VARCHAR(CURRENT_TIMESTAMP() :: TIMESTAMP, 'yyyy-mm-dd hh:mm:ss');

Recommendations

• No additional user actions are required.

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