Snippets
DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Erico has posted 5 posts at DZone. View Full User Profile

Calcular A Idade Em SQL

09.13.2009
| 6477 views |
  • submit to reddit 
        Faz o cálculo da idade de uma pessoa utilizando sql oracle


Select Trunc ( (SYSDATE - to_date('14/07/1980','dd/mm/yyyy')) /365, 0 ) as "age" from Dual
"Starting from scratch" is seductive but disease ridden
-Pithy Advice for Programmers