Hi, Nick Stuart,All >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. >>
Yes I have ever seen it before but it not my answer. I really want to get result something like "your age are 30 years old 6 month and 15 days." is it possible with SQL. Best regards. Kittiphum Worachat [EMAIL PROTECTED] --------------------------------------------------------------------- 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