Snowflake Intervals can only be used in arithmetic operations. Intervals used in any other scenario are not supported.
Example Code
Input Code Oracle:
IN -> Oracle_01.sql
SELECT INTERVAL '1-5' YEAR TO MONTH FROM DUAL;
Output Code:
OUT -> Oracle_01.sql
SELECT
!!!RESOLVE EWI!!! /*** SSC-EWI-0107 - INTERVAL LITERAL IS NOT SUPPORTED BY SNOWFLAKE IN THIS SCENARIO ***/!!!
INTERVAL '1-5' YEAR TO MONTH FROM DUAL;
Known Issues
No issues were found.
Related EWIS
: Interval Literal Not Supported In Current Scenario.