MSCEWI3096
Interval Literal Not Supported In Current Scenario
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
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
No end-user action is required.
If you need more support, you can email us at [email protected]
Last updated