MSCEWI2039

Input format not supported.

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

Severity

Medium

Description

The specified input format is not supported in Snowflake.

Example Code

Input Code:

SELECT
    CAST('01-12-2020' AS DATE FORMAT 'dd-mm-yyyy'),
    CAST('01-12-2020' AS DATE FORMAT 'DDDBEEEE');

Output Code:

SELECT
    TO_DATE('01-12-2020', 'DD-MM-YYYY') /*** MSC-WARNING - MSCEWI2025 - OUTPUT FORMAT 'dd-mm-yyyy' NOT SUPPORTED. ***/,
    TO_DATE('01-12-2020', 'DDD EEEE') /*** MSC-WARNING - MSCEWI2025 - OUTPUT FORMAT 'DDDBEEEE' NOT SUPPORTED. ***/ /*** MSC-ERROR - MSCEWI2039 - INPUT FORMAT 'DDD EEEE' NOT SUPPORTED ***/;

Recommendations

• Consider using one of the supported formats if possible.

• Take a look at the related documentation here.
• If you need more support, you can email us at [e-mail]