Breaking News: Grepper is joining You.com. Read the official announcement!

calculate age function in mysql

Add Answer

Mohamed Aladdin answered on April 26, 2020 Popularity 7/10 Helpfulness 1/10

answer calculate age function in mysql

related mysql calculate age

related mysql get age from date

related compute age mysql

calculate age function in mysql

Comment

drop function if exists getIdade;

delimiter |

create function getIdade( data_nascimento datetime )
returns int
begin
    declare idade int;
    declare ano_atual int;
    declare mes_atual int;
    declare dia_atual int;
    declare ano int;
    declare mes int;
    declare dia int;

    set ano_atual = year(curdate());
    set mes_atual = month( curdate());
    set dia_atual = day( curdate());

    set ano = year( data_nascimento );
    set mes = month( data_nascimento );
    set dia = day( data_nascimento );

    set idade = ano_atual - ano;

    if( mes > mes_atual ) then
            set idade = idade - 1;
    end if;

    if( mes = mes_atual and dia > dia_atual ) then
            set idade = idade - 1;
    end if;

    return idade;
end|

delimiter ;

Popularity 7/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: function mysql sql

Link to this answer
Share Copy Link

Contributed on Oct 14 2022

Mohamed Aladdin

0 Answers Avg Quality 2/10

Closely Related Answers

mysql calculate age

Comment

SELECT DATEDIFF(CURRENT_DATE, STR_TO_DATE(t.birthday, '%d-%m-%Y'))/365 AS ageInYears
  FROM YOUR_TABLE t

Popularity 10/10 Helpfulness 9/10 Language sql

Source: stackoverflow.com

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Apr 26 2020

Lively Lyrebird

0 Answers Avg Quality 2/10

mysql get age from date

Comment

SELECT YEAR(CURRENT_DATE)-YEAR(t.birthday) AS ageInYears
  FROM YOUR_TABLE t

Popularity 9/10 Helpfulness 8/10 Language sql

Source: Grepper

Tags: date

Link to this answer
Share Copy Link

Contributed on Aug 30 2021

Vivacious Vendace

0 Answers Avg Quality 2/10

compute age mysql

Comment

MySQL Compute a Persons Age

Popularity 8/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: mysql sql

Link to this answer
Share Copy Link

Contributed on Oct 26 2021

Shy Shrew

0 Answers Avg Quality 2/10

calculate age function in mysql

Contents

More Related Answers

calculate age function in mysql

Closely Related Answers

mysql calculate age

mysql get age from date

compute age mysql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.