One of the most asked questions in forums and discussion board is how a SQL function to extract year from date. This can be done in multiple ways as shown below.

sql function to extract year from date

 
Regards

Ahmad Osama

Like us on FaceBook Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook