MONTHS_BETWEEN

= = =MONTHS_BETWEEN=

FROM employees
===|| SYSDATE || ROUND(MONTHS_BETWEEN(SYSDATE,HIRE_DATE),0 || || 07-MAR-09 || 261 || || 07-MAR-09 || 234 || || 07-MAR-09 || 194 || || 07-MAR-09 || 258 || || 07-MAR-09 || 177 || || 07-MAR-09 || 177 || || 07-MAR-09 || 108 || || 07-MAR-09 || 154 || || 07-MAR-09 || 131 || || 07-MAR-09 || 117 || ===

FROM f_staffs
===|| BIRTHDATE || ROUND(MONTHS_BETWEEN(SYSDATE,BIRTHDATE),0) || || 01-JUL-80 || 344 || || 19-MAR-79 || 360 || || 30-MAR-69 || 479 || ===

FROM dual

 * SYSDATE || ROUND(MONTHS_BETWEEN('19-MAY-09',SYSDATE),0) ||
 * 07-MAR-09 || 2 ||