Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!
Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.
Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!
[Solved] MySQL - How to calculate an persons' Age based on a Date (DOB)
(@hans)
Famed Member Admin
Joined: 12 years ago
Posts: 2859
Topic starter
August 19, 2013 7:52 AM
Sometimes you need to determine the age of a person, given a data of birth (DOB) ... there is no given function in MySQL that can do this, but with the following query you'll be able to determine a persons' age (person_age), where "dob" is a date or date field:
SELECT
...
(YEAR(CURRENT_DATE) - YEAR(dob)) - (RIGHT(CURRENT_DATE, 5) < RIGHT(dob, 5)) AS person_age
...
FROM
...
