Mysql calcular idade

SELECT * 
FROM alunos a 
INNER JOIN matriculas m ON m.numero_matricula = a.numero_matricula 
WHERE YEAR(FROM_DAYS(TO_DAYS(m.data_matricula) - TO_DAYS(a.alunascimento))) < 17

Mysql calcular idade

SELECT
    YEAR(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(nascimento))) AS idade
FROM
    clientes

Source: pt.stackoverflow.com

Similar codes

1 vote236 views1 answer
Blob datatype in mysql
SQL
5 votes216 views2 answers
Oracle to_timestamp
SQL
0 vote225 views1 answer
How to put is null in where in clause
SQL
10 votes210 views2 answers
Mysql select timestamp group by day
SQL
1 vote237 views2 answers
Sql server concat string and int
SQL
0 vote236 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote549 views1 answer
Sql field equals multiple values
SQL
0 vote242 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote234 views1 answer
SQL: calculate hours from two dates
SQL
4 votes193 views1 answer
Install postgres 12 on ubuntu
SQL