SSC-EWI-PG0001
Age is not supported on Snowflake
Severity
Medium
Description
This error is added because SnowConvert does not support the age()
functionality.
Code Example
Input Code:
SELECT
age(date1::date, date2::date)
FROM
Table1;
Output Code:
SELECT
!!!RESOLVE EWI!!! /*** SSC-EWI-PG0001 - AGE IS NOT SUPPORTED ON SNOWFLAKE. ***/!!!
age(date1::date, date2::date)
FROM
Table1;
Recommendations
The
Datediff
time function can solve some cases where the objective of the query is to obtain a specific range of values but this has to be handled manually for each scenario. For more information please refer to the Snowflake documentation about Datediff.If you need more support, you can email us at [email protected]
Last updated