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:
SELECT INTERVAL '1-5' YEAR TO MONTH FROM DUAL;
Output Code:
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
SSC-EWI-0107: Interval Literal Not Supported In Current Scenario.
Last updated