Solved programming problem

From the employees table, show each employees employee_id, join_date and estimated retirement date that is 30 years after his join_date

Source code

SELECT EMPLOYEE_ID,HIRE_DATE,DATE_ADD(HIRE_DATE,INTERVAL 30 YEAR)

FROM employees;
Join the discussion

Add your comment