Answers

2015-02-04T11:08:41+05:30
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

0