以下查询返回:
SELECT AGE(cast(dob AS date))
FROM mas_patient_details;
age
----------
39 years 5 mons 19 days
13 years 2 days
69 years 2 days
41 years 11 mons 25 days
这个查询返回:
SELECT age(cast(dob as date))
FROM mas_patient_details
WHERE age <= 59;
age
----------
39 years 5 mons 19 days
13 years 2 days
69 years 2 days
41 years 11 mons 25
如何简单地从这些查询中提取年份?