Consider two fields-B_date, which stores the birth date, and J_date, which stores

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 joining date.

Answer :-

Select  ( year( J_date ) - year( B_date )  ) as “Age”  from employee ;