ROUND+(date)

 =ROUND = 

  Description:
 This function is use to round dates. It is also use to round number but in this case, just dates.



SELECT last_name, first_name,hire_date, ROUND(MONTHS_BETWEEN(SYSDATE,hire_date),0) FROM employees
===|| LAST_NAME || FIRST_NAME || HIRE_DATE || ROUND(MONTHS_BETWEEN(SYSDATE,HIRE_DATE),0) || || King || Steven || 17-JUN-87 || 261 || || Kochhar || Neena || 13-JAN-93 || 234 || || De Hann || Lex || 21-SEP-89 || 194 || || Whalen || Jennifer || 17-SEP-87 || 264 || || Higgins || Shelley || 07-JUN-94 || 177 || || Gletz || William || 07-JUN-94 || 177 || || Zlotkey || Eleni || 29-JAN-00 || 109 || || Abel || Ellen || 11-MAY-96 || 154 || || Taylor || Jonathon || 24-MAR-96 || 131 || || Grant || Kimberly || 24-MAR-99 || 117 || ===

SELECT last_name, first_name, birthdate, ROUND( MONTHS_BETWEEN(SYSDATE, birthdate),0) FROM f_staffs

 * LAST_NAME || FIRST_NAME || BIRTHDATE || ROUND(MONTHS_BETWEEN(SYSDATE,BIRTHDATE),0) ||
 * Doe || Sue || 01-JUL-80 || 344 ||
 * Miller || Bob || 19-MAR-79 || 360 ||
 * Tuttle || Monique || 30-MAR-79 || 479 ||

FROM dual

 * '09-AUG-09 || ROUND(MONTHS_BETWEEN('09-AUG-09',SYSDATE),0) ||
 * 09-AUG-09 || 5 ||