Advertisement
Guest User

Untitled

a guest
Jul 29th, 2014
204
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. SELECT
  2. FLOOR(DATEDIFF(NOW(), c.nascimento) / 365) AS idade
  3. FROM
  4. clientes c
  5.  
  6. SELECT
  7. YEAR(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(c.nascimento))) AS idade
  8. FROM
  9. clientes
  10.  
  11. TIMESTAMPDIFF(YEAR, c.nascimento, NOW()) AS idade
  12.  
  13. SUBSTRING(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(c.nascimento)), 3, 2) AS idade
  14.  
  15. SELECT YEAR(dHoje)-YEAR(dNasc)-IIF(MONTH(dHoje)*32+DAY(dHoje)<MONTH(dNasc)*32+DAY(dNasc),1,0)
  16.  
  17. SELECT
  18. TIMESTAMPDIFF(YEAR, c.nascimento, CURDATE()) as idade
  19. FROM
  20. clientes c
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement