Posted By

mpcircuitry on 12/12/09


Tagged

mysql db


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

dantreacy
kubaitis
virendrakryadav


MySQL Age Calucation


 / Published in: MySQL
 

Some code I found for calculating and determining a persons age

  1. DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(DOB, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(DOB, '00-%m-%d')) >= 65

Report this snippet  

You need to login to post a comment.