Please refer to http://mysql.com/doc/D/a/Date_calculations.html it covers datecalculations and has specifics on Age calcs.
-Nick > Hello, mysql, > > How to get Age from field date-time that contain dateofbirth and then > display as xx year yy month zz days. > > Best regards. > > Kittiphum Worachat > [EMAIL PROTECTED] > 2002-05-15 > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <mysql- [EMAIL PROTECTED]> To > unsubscribe, e-mail > <mysql-unsubscribe- [EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php