Age From Dob

Age from DOB

Using TIMESTAMPDIFF

SELECT name, dob,
  TIMESTAMPDIFF(YEAR, dob, CURDATE()) AS age
FROM students;

How it Works

Summary

• Use TIMESTAMPDIFF(YEAR, dob, CURDATE()) for exact age in years.
• CURDATE() gives today's date.

DOB से Age

TIMESTAMPDIFF से

SELECT name, dob,
  TIMESTAMPDIFF(YEAR, dob, CURDATE()) AS age
FROM students;

कैसे काम करता है

सारांश

• Exact age (years) के लिए TIMESTAMPDIFF(YEAR, dob, CURDATE()) use करें।
• CURDATE() आज की date देता है।