Thursday, January 3, 2008

Calculating age in Oracle

It is more accurate by using MONTH_BETWEEN than 365 day due to leap years:

floor(MONTHS_BETWEEN(to_date($RptYear, 'dd-mon-yyyy'),BIRTHDATE)/12)

No comments: