JOIN NOW

Informatics Practices

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

SQL Queries

6 Likes

Answer

SELECT (YEAR(CURDATE()) - YEAR(B_DATE)) AS AGE FROM EMPLOYEE;

Answered By

1 Like

Related Questions