SELECT EMPLOYEE_ID,
CONCAT(DATEDIFF(CURDATE(),HIRE_DATE) DIV 365 ," years, ",(DATEDIFF(CURDATE(),HIRE_DATE) MOD 365) DIV 30," months and ",DATEDIFF(CURDATE(),HIRE_DATE) MOD 30)
FROM employees;
SELECT EMPLOYEE_ID,
CONCAT(DATEDIFF(CURDATE(),HIRE_DATE) DIV 365 ," years, ",(DATEDIFF(CURDATE(),HIRE_DATE) MOD 365) DIV 30," months and ",DATEDIFF(CURDATE(),HIRE_DATE) MOD 30)
FROM employees;
Add your comment