Solved programming problem

Show each employees employee_id and his total current experience(upto present date) in number of years format

Source code

SELECT EMPLOYEE_ID,ROUND(DATEDIFF(CURDATE(),HIRE_DATE)/365,3)

FROM employees;
Join the discussion

Add your comment