Calculate age based on date of birth

Question

I have a table of users in sql and they each have birth dates  I want to convert their date of birth to their age  years only   e g  date  15 03 1999 age  14 and 15 03 2014 will change to age  15  Here I want to show the date of the user   if isset   GET  id            id   intval   GET  id          dnn   mysql fetch array  dn        dn   mysql query  select username  email  skype  avatar               date  signup date  gender from users where id     id            dnn   mysql fetch array  dn       echo    dnn  date

User · Answer

declare  dateOfBirth date select  dateOfBirth    2000-01-01   SELECT datediff YEAR  dateOfBirth getdate    as Age

User · Answer

Got this script from net  thanks to coffeecupweb    lt  php        Simple PHP age Calculator        Calculate and returns age based on the date provided by the user      param   date of birth  Format yyyy-mm-dd        return  age based on date of birth     function ageCalculator  dob       if  empty  dob             birthdate   new DateTime  dob            today     new DateTime  today             age    birthdate- gt diff  today - gt y          return  age       else          return 0           dob    1992-03-18   echo ageCalculator  dob     gt

User · Answer

Very small code to get Age    lt  php      dob  1981-10-07        diff    date  Y   - date  Y  strtotime  dob         echo  diff    gt     output 35

User · Answer

getyear   explode  -    value  users dob      dob   date  Y   -  getyear 0      value  users dob   is the database value with format yyyy-mm-dd

User · Answer

Reference Link http   www calculator net age-calculator html   hours in day     24   minutes in hour  60   seconds in mins  60    birth date       new DateTime  1988-07-31T00 00 00     current date     new DateTime      diff              birth date- gt diff  current date    echo  years        diff- gt y     years      diff- gt m     months      diff- gt d     day s    echo   lt br  gt    echo  months        diff- gt y   12     diff- gt m     months      diff- gt d     day s    echo   lt br  gt    echo  weeks       floor  diff- gt days 7      weeks      diff- gt d 7     day s    echo   lt br  gt    echo  days         diff- gt days     days   echo   lt br  gt    echo  hours        diff- gt h     diff- gt days    hours in day      hours   echo   lt br  gt    echo  mins         diff- gt h     diff- gt days    hours in day    minutes in hour      minutest   echo   lt br  gt    echo  seconds      diff- gt h     diff- gt days    hours in day    minutes in hour    seconds in mins      seconds   echo   lt br  gt

User · Answer

PHP  gt   5 3 0   object oriented  from   new DateTime  1970-02-01     to     new DateTime  today    echo  from- gt diff  to - gt y     procedural echo date diff date create  1970-02-01    date create  today   - gt y   demo functions  date create    date diff    MySQL  gt   5 0 0 SELECT TIMESTAMPDIFF YEAR   1970-02-01   CURDATE    AS age  demo functions  TIMESTAMPDIFF    CURDATE

User · Answer

To Calculate age from Date of birth used used query like this    SELECT username  email  skype  avatar  TIMESTAMPDIFF YEAR  date  CURDATE    AS age  signup date  gender FROM users WHERE id     id        if isset   GET  id            id   intval   GET  id           dn   mysql query  select username  email  skype  avatar  TIMESTAMPDIFF YEAR  date  CURDATE    AS age  signup date  gender from users where id     id             dnn   mysql fetch array  dn        echo  dnn  age        Note  don t use reserved keywords column name

User · Answer

I hope you will find this useful    query1  SELECT TIMESTAMPDIFF  YEAR  YOUR DOB COLUMN  CURDATE    AS age FROM your table WHERE id   user id     res1 mysql query  query1    row mysql fetch array  res1   echo  row  age

User · Answer

There is a simple way to find the date from any birthdate by using substr of PHP   birth date    15 03 2014    date   substr  birth date  0  2   echo  date    Which will just simply give you the output date of that birth date   In this case  that will be 15   See substr of PHP for more

User · Answer

For a birthday date with format Date Month Year  function age  birthday    list  day   month   year    explode       birthday     year diff    date  Y   -  year    month diff   date  m   -  month    day diff     date  d   -  day   if   day diff  lt  0  amp  amp   month diff  0   year diff--   if   day diff  lt  0  amp  amp   month diff  lt  0   year diff--   return  year diff      or the same function that accepts day  month  year as parameters    function age  day   month   year     year diff    date  Y   -  year    month diff   date  m   -  month    day diff     date  d   -  day   if   day diff  lt  0  amp  amp   month diff  0   year diff--   if   day diff  lt  0  amp  amp   month diff  lt  0   year diff--   return  year diff      You can use it like this    echo age  20 01 2000      which will output the correct age  On 4 June  it s 14

User · Answer

dob    this- gt dateOfBirth    Datetime           currentDate   new  DateTime             dateDiff    dob- gt diff  currentDate            years    dateDiff- gt y           months    dateDiff- gt m           days    dateDiff- gt d           age    years    Year s             if  years     0                 age    months    Month s                if  months     0                     age    days    Day s                                    return  age

[php] Calculate age based on date of birth

Examples related to php

Examples related to mysql

Examples related to date