mysql query on dob

Question

If DOB is given in this porder- 1853-03-12 , then how do we find the youngest person from table bases on this type of data. If the year is same but month is different for 2 persons.

I tried MIN(dob)- it gives me the oldest person and When I tried MAX, it gives me nothing.

Answer 1

It's weird, however you can use ORDER BY dob DESC LIMIT 1

What's your full query ?

EDIT : resolved by email ^^

Answer 2

MAX should usualy do the job. maybe you have any datasets with NULL-value in that column? one thing you could try is to ORDER BY dob DESC and LIMIT 1.