This is a deprecated version of the SnowConvert documentation, please visit the official site .
The specified input format is not supported in Snowflake.
SELECT
CAST('01-12-2020' AS DATE FORMAT 'dd-mm-yyyy'),
CAST('01-12-2020' AS DATE FORMAT 'DDDBEEEE');
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 ***/;