DELIMITER //

CREATE PROCEDURE FindEmployeeBirthYearByID(IN emp_id INT, OUT birth_year INT) BEGIN SELECT YEAR(birth_date) INTO birth_year FROM employees WHERE Employee_id = emp_id; END // DELIMITER ;

CALL FindEmployeeBirthYearByID(5004, @birth_year); SELECT @birth_year AS Employee_5004_BirthYear;

CALL FindEmployeeBirthYearByID(5018, @birth_year); SELECT @birth_year AS Employee_5018_BirthYear;

CALL FindEmployeeBirthYearByID(5029, @birth_year); SELECT @birth_year AS Employee_5029_BirthYear;