Calculate age in years from DOB
SQL
Hard
2 views
Problem Description
Customers(dob). Return customer_id and age_years as integer (approx).
Sample Test Case
Input:
Customers(customer_id, dob)
Constraints
Date functions vary; show EXTRACT approach
Official Solution
SELECT customer_id, EXTRACT(YEAR FROM AGE(CURRENT_DATE, dob)) AS age_years FROM Customers;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!