MSCEWI3011

The format parameter is not supported.

Severity

Medium

Description

The format parameter is not currently supported by Snowflake for Cast functions.

Example Code

Input Code:

SELECT CAST('12.48' AS NUMBER, '99.99') FROM DUAL;

Output Code:

SELECT
  /*** MSC-ERROR - MSCEWI3011 - THE FORMAT PARAMETER IS NOT SUPPORTED ***/
  TO_NUMBER('12.48' , '99.99') FROM DUAL;

Recommendations