Getting age in years - SQL / PHPMyAdmin

Question

i want to see the age in years of my clients in my database.

The table is called 'clients' and the clients have set a birth of date (example:1992-04-04). But i want to see it like this: Age: 17 (for example). How can i do this?

I need the SQL Query for this.. i tried DATEDIFF but i just cant get it working

Possible duplicate of [calculate age based on date of birth](http://stackoverflow.com/questions/19521146/calculate-age-based-on-date-of-birth) — Saty, Apr 07 '16 at 12:08

score 0 · Answer 1 · answered Apr 07 '16 at 12:18

0

SELECT TIMESTAMPDIFF(YEAR,'2003-05-01', NOW());

Of course you put your birthdate selected from proper table instead of '2003-05-01' :-)

answered Apr 07 '16 at 12:18

DevilaN

1,317
10
21

Getting age in years - SQL / PHPMyAdmin

1 Answers1