erraja_07 on 03/23/11
Last Edited at 03/23/11 10:22pm
SELECT DATE_FORMAT( FROM_DAYS( TO_DAYS( NOW( ) ) - TO_DAYS( dob ) ) , '%Y' ) +0 AS ageFROM table_nameWHERE `usersid` =14LIMIT 0 , 30
URL: http://ma.tt/2003/12/calculate-age-in-mysql/
Report this snippet Tweet
Comment:
You need to login to post a comment.