SSC-EWI-RS0007

Date literal is not supported in Snowflake.

Severity

High

Description

Some DATE, TIME, or TIMESTAMP formats are not supported in Snowflake. These formats may require manual manipulation.

Code Example

Input Code:

IN -> Redshift_01.sql

select datediff(century, '2000-Jan-31', 'Jan-31-2000');

Output Code:

OUT -> Redshift_01.sql

 select
 DATEDIFF(YEAR,
                !!!RESOLVE EWI!!! /*** SSC-EWI-RS0007 - '2000-Jan-31' DATE LITERAL IS NOT SUPPORTED IN SNOWFLAKE. ***/!!!
                '2000-Jan-31',
                               !!!RESOLVE EWI!!! /*** SSC-EWI-RS0007 - 'Jan-31-2000' DATE LITERAL IS NOT SUPPORTED IN SNOWFLAKE. ***/!!!
                               'Jan-31-2000') / 100;

Recommendations

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