/SQL/Mysql calculate age from date of birth

Mysql calculate age from date of birth

Mysql calculate age

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

Source: stackoverflow.com

Compute age mysql

MySQL Compute a Persons Age

Source: grepper.com

Calculate age function in mysql

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 ;

Source: stackoverflow.com

Similar codes

0 vote186 views1 answer
Create table using the clause with as
SQL
3 votes228 views2 answers
Find string in stored procedure sql server
SQL
0 vote166 views1 answer
Postgresql where clause not working
SQL
0 vote191 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote205 views1 answer
Arithmetic expression in sql
SQL
8 votes200 views1 answer
Ltrim sql
SQL
0 vote176 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
2 votes166 views1 answer
Sql create database
SQL
0 vote165 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote180 views1 answer
Supprimer les valeur d'une table mysql
SQL