List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 30 2002 8:38pm
Subject:RE: Calculate current age with given birthday
View as plain text  
At 21:25 +0100 3/30/02, Roger Baklund wrote:
>* Son Nguyen
>>  ==> I tried this query, but... it's not working out:
>>    SELECT YEAR(now()-birthday) from users where loginName="test";
>
>You are very close:
>
>SELECT YEAR(now())-YEAR(birthday) as age from users where loginName="test";

That won't adjust for the relative difference within the calendar
year of the two dates.  This works better:

mysql> SELECT
     -> YEAR(CURDATE()) - YEAR(birthday)
     -> - IF(RIGHT(CURDATE(),5) < RIGHT(birthday,5),1,0)
     -> AS 'age in years'
     -> FROM users WHERRE loginName="test";

>
>--
>Roger
>query

Thread
LIMIT, ORDER Dilemadestr030 Mar
  • Re: LIMIT, ORDER DilemaTyler Longren30 Mar
  • Re: LIMIT, ORDER DilemaPaul DuBois30 Mar
Re: LIMIT, ORDER Dilemadestr030 Mar
  • Re: LIMIT, ORDER DilemaPaul DuBois30 Mar
Re: LIMIT, ORDER Dilemadestr030 Mar
  • Re: LIMIT, ORDER DilemaPaul DuBois30 Mar
    • RE: LIMIT, ORDER DilemaRoger Baklund30 Mar
      • RE: LIMIT, ORDER DilemaPaul DuBois30 Mar
  • Calculate current age with given birthdaySon Nguyen30 Mar
    • RE: Calculate current age with given birthdayRoger Baklund30 Mar
      • RE: Calculate current age with given birthdayPaul DuBois30 Mar
        • RE: Calculate current age with given birthdayMichael Stassen30 Mar
Re: LIMIT, ORDER DilemaSteven Roussey30 Mar
RE: Calculate current age with given birthdayPaul DuBois31 Mar
  • RE: Calculate current age with given birthdayMichael Stassen2 Apr