How to get year in sql

[abhaysingh]

Hi,

Like in Qlik with year(Today()) we get output as 2016

In Sql to get Current Year what would be the syntax?

[Colin-Albert]

For SQL Server use     year(getdate())

[abhaysingh]

Hi,

Getting below error.. pls suggest