MSCEWI2039

Input format not supported.

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.
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI2038

MSCEWI2040

Last modified 1yr ago