Advanced Search

Calculate Age from Date Of Birth

/ Published in: MySQL
Save to your folder(s)
It's not 100% accurate, but works fine for people under 1.480.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT FLOOR(DATEDIFF(CURRENT_DATE(), dob) / 365);

URL: http://ma.tt/2003/12/calculate-age-in-mysql/#comment-462995

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.