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

3 votes183 views1 answer
Search for column name in psql
SQL
1 vote223 views1 answer
Mysql select all and rename one
SQL
1 vote207 views1 answer
Increase existing date in sql
SQL
0 vote200 views1 answer
Mysql update from select on same table
SQL
0 vote195 views1 answer
Mysql terminal list table
SQL
0 vote195 views1 answer
How much table store postgres
SQL
9 votes201 views3 answers
Oracle undo usage by session
SQL
0 vote284 views1 answer
Add computed column to table sql server
SQL
1 vote185 views1 answer
Get count by weekly pivot table sql server
SQL
5 votes195 views1 answer
How to check nls format in oracle
SQL