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

How to Find Years of Service of Employee

Leave a Reply

Your email address will not be published. Required fields are marked *

+ 54 = sixty two