How to only get Year as part of date / datetime in SQL Server

Question

When I create a date type in SQL, the result will come out like this 2012-2-1 Monday 00:00:00

However, I only want the year.

How can I get this?

Answer 1

Make an numeric field with just the year, or use the YEAR() function.

Answer 2

datetime, includes date and time, "date" just includes date formats.

select datepart(year,getdate())