Simpler ways of calculating years between
29240Apr 11 2006 — edited Apr 11 2008Hi again,
I would appreciate numerous versions of calculating years between in years of age
i think there should be simpler ones than this below:
SQL> select floor(months_between(hire_date,dob)/12) age from employee;
AGE
----------
38
32
30
46
39
25
32
46
39
33
10 rows selected.
many thanks
cube60