I need an sql command that returns the person's age. I have the date of birth of the person in the bank, I need to calculate their age by SQL.
How to calculate the age of a person in Oracle SQL?
4
asked by anonymous 12.06.2017 / 19:59
1 answer
6
I do
NVL(Floor(Months_Between(DtCalc,DtNasc)/12),0)
is a solution
I actually use a function for this.
12.06.2017 / 20:13