Re: Re: Age calculation
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
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
Re: Age calculation
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 To > unsubscribe, e-mail > 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
Age calculation
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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php