Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- FLOOR(DATEDIFF(NOW(), c.nascimento) / 365) AS idade
- FROM
- clientes c
- SELECT
- YEAR(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(c.nascimento))) AS idade
- FROM
- clientes
- TIMESTAMPDIFF(YEAR, c.nascimento, NOW()) AS idade
- SUBSTRING(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(c.nascimento)), 3, 2) AS idade
- SELECT YEAR(dHoje)-YEAR(dNasc)-IIF(MONTH(dHoje)*32+DAY(dHoje)<MONTH(dNasc)*32+DAY(dNasc),1,0)
- SELECT
- TIMESTAMPDIFF(YEAR, c.nascimento, CURDATE()) as idade
- FROM
- clientes c
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement