How can I calculate age based on the current date in Snowflake?

To calculate age based on the current date in Snowflake, you can use the DATEDIFF function along with the CURRENT_DATE function. Here's how you can do it:

1. Using DATEDIFF Function:

- The DATEDIFF function calculates the difference between two dates. You can use it to find the difference in years between the birth date and the current date.

2. Using CURRENT_DATE Function:

- The CURRENT_DATE function returns the current date.

3. Example SQL Query:

SELECT
  DATEDIFF(year, birth_date, CURRENT_DATE) AS age
FROM
  your_table;


- Replace your_table with the name of your table and birth_date with the column containing the birth dates.

4. Handling Null Birth Dates:

- If your birth_date column can contain null values, you might want to handle them to avoid errors. You can use the COALESCE function or a CASE statement.

5. Example with Null Handling:

SELECT
  CASE
    WHEN birth_date IS NULL THEN NULL
    ELSE DATEDIFF(year, birth_date, CURRENT_DATE)
  END AS age
FROM
  your_table;


6. Explanation:

- The DATEDIFF(year, birth_date, CURRENT_DATE) calculates the difference in years between the birth_date and the CURRENT_DATE.

- The CASE statement checks if birth_date is null. If it is, it returns null; otherwise, it calculates the age.

By using these SQL queries, you can effectively calculate the age of individuals based on their birth dates and the current date in Snowflake. Remember to adjust the table and column names to match your specific schema.

Learn more about this