Question

Write a query in mysql to display ename, job, and date of retirement(60 years after hiredate) from employee table.

Answer 1

SELECT EName,Job,DateOfJoing,DATE_ADD(DateOfJoing,INTERVAL 60 YEAR) AS DateOfRetirement FROM EmployeeTable

Note: I have added DateOfJoing in your Query for better understanding ok,If you don't need it you may remove like below..

SELECT EName,Job,DATE_ADD(DateOfJoing,INTERVAL 60 YEAR) AS DateOfRetirement FROM EmployeeTable