SSC-EWI-OR0008

Unknown format, it may have unexpected behavior.

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.

Severity

Low

Description

This error is added for unknown date formats that may have unexpected behavior.

Example Code

Input Code:

SELECT TO_CHAR(DATE '1998-12-25','iw-iyyy') FROM DUAL;

Output Code:

SELECT
!!!RESOLVE EWI!!! /*** SSC-EWI-OR0008 - UNKNOWN FORMAT, MAY HAVE UNEXPECTED BEHAVIOR ***/!!!
 TO_CHAR(DATE '1998-12-25','iw-iyyy'') FROM DUAL;

Note that 'iw-iyyy'' is not a supported format.

Recommendations

• Check for this documentation for the supported timestamp formats.

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