Links

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.