SSC-FDM-OR0026

Type not supported in cast operation.

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

This FDM is deprecated, please refer to SSC-EWI-OR0045 documentation.

Description

This error happens when a type is not supported in a cast operation.

Example

Input Code:

select cast(' $123.45' as number, 'L999.99') from dual;

Output Code:

select
--** SSC-FDM-OR0026 - CAST TYPE NOT SUPPORTED **
!!!RESOLVE EWI!!! /*** SSC-EWI-OR0011 - THE FORMAT PARAMETER ' $123.45' IS NOT SUPPORTED ***/!!!
 cast(' $123.45' as NUMBER(38, 18) , 'L999.99') from dual;

Related EWIs

1. SSC-EWI-OR0011: The format parameter is not supported.

Recommendations

• The cast is converted to a user-defined function (UDF/Stub), so you can modify it to emulate the behavior of the cast function.

• If you need more support, you can email us at [email protected]