In SQL, you can determine a person’s year of birth using the DATEPART function to extract the year from their birthdate.
source
SQL Server advanced concept Calculate the year of birth based on age
In SQL, you can determine a person’s year of birth using the DATEPART function to extract the year from their birthdate.
source