Links

MSCEWI4068

Timestamp format was not found.

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]