MYSQL query to calculate Date of Birth - MySQL Snipplr Social Repository

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