How to extract only the year from the date in sql server 2008

Question

How to simply get the year from the date in SQL Server 2008 I need to extract the year from the date column in my database. Does that serve any purpose?

Answer 1

To obtain the year from the given date, use the year() function in SQL.

Syntax:

YEAR ( date )