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

0 vote179 views1 answer
Call rest api from postgresql
SQL
0 vote179 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
10 votes191 views4 answers
Primary key in sql
SQL
0 vote204 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
7 votes222 views1 answer
Show line number in sql server
SQL
2 votes169 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
5 votes190 views1 answer
Get column name sql server
SQL
1 vote183 views2 answers
Grab part of a string sql
SQL
0 vote183 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote177 views1 answer
Mariadb datetime change to microseconds
SQL