Last updated 1 year ago
Default on conversion error not supported in Snowflake
You might create UDF to emulate the behavior of DEFAULT value ON CONVERSION ERROR.
DEFAULT
ON CONVERSION ERROR
If you need more support, you can email us at
DEFAULT ON CONVERSION ERROR is not supported.
SELECT TO_NUMBER('2,00' DEFAULT 0 ON CONVERSION ERROR) "Value" FROM DUAL;
SELECT !!!RESOLVE EWI!!! /*** SSC-EWI-OR0029 - DEFAULT ON CONVERSION ERROR NOT SUPPORTED IN SNOWFLAKE ***/!!! TO_NUMBER('2,00') "Value" FROM DUAL;