How to extract the YEAR in SQL Server 2008?

How to extract the YEAR in SQL Server 2008?

References

Reference NO 1

http://stackoverflow.com/questions/12436743/how-to-extract-only-the-year-from-the-date-in-sql-server-2008

Reference NO 2

http://technet.microsoft.com/en-us/library/ms186313.aspx

Reference NO 3

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/371b0113-4122-4a18-a27c-681ff5ba8716/action?threadDisplayName=extracting-only-year-from-getdate-function

Reference NO 4

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=96889

Reference NO 5

http://blog.sqlauthority.com/2008/08/14/sql-server-get-date-time-in-any-format-udf-user-defined-functions/

Reference NO 6

http://blog.sqlauthority.com/2007/06/10/sql-server-retrieve-select-only-date-part-from-datetime-best-practice/

Reference NO 7

http://www.w3schools.com/sql/sql_dates.asp

Reference NO 8

#EANF#