You probably need a computational module that calculates age with leap year calculation support. :-)
Pae ----- Original Message ----- From: "Kittiphum Worachat" <[EMAIL PROTECTED]> To: "Nick Stuart" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 6:38 PM Subject: Re: Re: Age calculation > 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 > --------------------------------------------------------------------- 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
