Write commands to find out and display the approximate age of an employee as on today.

Q. Consider two fields B_date, which stores the birth date and J_date, which stores the joining date of an employee. Write commands to find out and display the approximate age of an employee as on today.

Answer =

SELECT YEAR (CURDATE() ) - YEAR ( B_date ), employee FROM empl ;