Interval Literal

Interval Literal Not Supported In Current Scenario

Description

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;

Recommendations

• No end-user action is required.

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

Related EWIS

1. SSC-EWI-0107: INTERVAL LITERAL IS NOT SUPPORTED BY SNOWFLAKE IN THIS SCENARIO