Thursday, July 30, 2009

Calculate age

SELECT TRUNC(MONTHS_BETWEEN(SYSDATE,A.BIRTHDATE)/12) AS AGE
FROM PS_PERSON A

No comments:

Post a Comment