How to select only year from a Date Time TSQL

Question

I'm right now creating View and I need to display only the YEAR from a normal DateTime
How can I do that to return just a Year as a value from ? I have already tried it with EXTRACT but somehow it not working .. Thanks for help and fast answer

Answer 1

Use YEAR() function

SELECT YEAR(MyDateCol) FROM MyTable

See this SQLFiddle

Answer 2

You can use DATEPART() to extract the year from datetime value.

DATEPART(YEAR,GETDATE());

Check out SQLFIDDLE