Age

Date/Time Function

Description

Subtract arguments, producing a “symbolic” result that uses years and months, rather than just days.

Click here to navigate to the Postgre docs page for this syntax.

Age is not supported on Snowflake

Grammar Syntax

 AGE ( timestamp, timestamp )

Sample Source Patterns

Postgre

Code 1

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

Snowflake

Code 1

SELECT
  -- ** MSC-WARNING - MSC-PG0001 - AGE IS NOT SUPPORTED IN SNOWFLAKE **
  -- age(date1::date, date2::date)
FROM
   Table1

Related EWIs

1. MSC-PG0001: AGE IS NOT SUPPORTED ON SNOWFLAKE