The AGE function is ok, but it will only return an approximation.
From the docs
1 to 60 days - 'nn DAYS'
61 days to 24 months - 'nn MOS'
(2 years + 1 month) to 999 years - 'nnn YRS
So if I put a DOB of 1 Jan 1966 and used the current date as 1 Feb 2024, I would only get back the years. I guess you could do some trickery to parse the returned string and perform some date math to get a result of Years Months Day. But I think for that some calculation method would be better, taking into account leap years etc.