MSCEWI3096

Interval Literal Not Supported In Current Scenario

Severity

High

Description

Snowflake Intervals can only be used in arithmetic operations. Intervals used in any other scenario are not supported.

Example Code

Input Code:

SELECT INTERVAL '1-5' YEAR TO MONTH FROM DUAL;

Output Code:

SELECT
-- ** MSC-ERROR - MSCEWI3096 - INTERVAL LITERAL IS NOT SUPPORTED BY SNOWFLAKE IN THIS SCENARIO  **
--       INTERVAL '1-5' YEAR TO MONTH
                                    FROM DUAL;

Recommendations