Return to Snippet

Revision: 43432
at March 23, 2011 22:22 by erraja_07


Initial Code
SELECT DATE_FORMAT( FROM_DAYS( TO_DAYS( NOW( ) ) - TO_DAYS( dob ) ) , '%Y' ) +0 AS age
FROM table_name
WHERE `usersid` =14
LIMIT 0 , 30

Initial URL
http://ma.tt/2003/12/calculate-age-in-mysql/

Initial Description


Initial Title
MYSQL query to calculate Date of Birth

Initial Tags


Initial Language
MySQL