Find Years of Service of Employee

If you need to find the number of years someone has worked for you then the following type of query should do the trick:

SELECT EMPNO, ENAME,
TRUNC((SYSDATE-HIREDATE)/365) as YEARS_OF_SERVICE
FROM EMP

ORACLE BOOKS

PRODUCTS MENU

COMPUTER MAGAZINES

COMPETITIONS / ADS