Well, actually I always use the Unix date format because is easier to use with PHP... and makes easier to do this kind of calculations... ;)
-----Mensaje original----- De: John Meyer [mailto:johnmeyer_1978@;yahoo.com] Enviado el: jueves, 07 de noviembre de 2002 15:20 Para: Michael T. Babcock CC: [EMAIL PROTECTED] Asunto: RE: getting the number of years between two dates Actually figured out one of my own: FLOOR(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()),EXTRACT(YEAR_MONTH FROM UserDOB))/ 12) as Age It's amazing what you can think of as soon as you ask the question. -----Original Message----- From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net] Sent: Thursday, November 07, 2002 1:58 PM To: John Meyer Cc: [EMAIL PROTECTED] Subject: Re: getting the number of years between two dates John Meyer wrote: >sql,query > >How do I do that? The contaxt is that I want to get somebody's age based >upon the current date. > > There are several examples in the mailing list archives; but try subtracting the UNIX_TIMESTAMP of each date (which is the time in seconds) and then divide by the number of seconds in a year (~365*86400) ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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