select where date current years code example

Example: get current year sql

select year(getdate())