Skip to content

Instantly share code, notes, and snippets.

@miguelcperez

miguelcperez/AgeCalculator.txt

Last active July 3, 2017 04:25
Show Gist options
  • Save miguelcperez/05e10e34e947ecb15e7bddcb05bbc90c to your computer and use it in GitHub Desktop.
Save miguelcperez/05e10e34e947ecb15e7bddcb05bbc90c to your computer and use it in GitHub Desktop.
Download ZIP
Oracle Age Calculator Function
Raw
AgeCalculator.txt
TRUNC((trunc(sysdate-fechanacimiento) )/365.25),0)
trunc(trunc(trunc(sysdate-fechanacimiento) - (365.25 * TRUNC(trunc(sysdate-fechanacimiento) )/365.25,0)))/ 30.4375)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment