MSC-PG0001

Age is not supported on Snowflake

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium

Description

This error is added because SnowConvert does not support the age() functionality.

Code Example

Input Code:

Code1

SELECT
   age(date1::date, date2::date),
FROM
   Table1;

Output Code:

Code1

SELECT
-- ** MSC-ERROR - MSC-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 refer to the Snowflake documentation about Datediff.

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