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

compute age mysql

Add Answer

Shy Shrew answered on April 26, 2020 Popularity 8/10 Helpfulness 1/10

answer compute age mysql

related mysql calculate age

related mysql get age from date

related calculate age function in mysql

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

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

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 8/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: function mysql mysq

Link to this answer
Share Copy Link

Contributed on Oct 14 2022

Mohamed Aladdin

0 Answers Avg Quality 2/10

compute age mysql

Contents

More Related Answers

compute age mysql

Closely Related Answers

mysql calculate age

mysql get age from date

calculate age function in mysql

Grepper

Documentation

Social

Legal

Contact

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