topic How to get year in sql in QlikView

topic How to get year in sql in QlikView https://community.qlik.com/t5/QlikView/How-to-get-year-in-sql/m-p/1119451#M904644 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Like in Qlik with year(Today()) we get output as 2016</P><P></P><P>In Sql to get Current Year what would be the syntax?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT abhaysingh 2020-11-25T16:16:04Z How to get year in sql https://community.qlik.com/t5/QlikView/How-to-get-year-in-sql/m-p/1119451#M904644 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Like in Qlik with year(Today()) we get output as 2016</P><P></P><P>In Sql to get Current Year what would be the syntax?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-year-in-sql/m-p/1119451#M904644 abhaysingh 2020-11-25T16:16:04Z Re: How to get year in sql https://community.qlik.com/t5/QlikView/How-to-get-year-in-sql/m-p/1119452#M904645 <HTML><HEAD></HEAD><BODY><P>For SQL Server use     year(getdate())</P></BODY></HTML> Fri, 08 Jul 2016 12:56:32 GMT https://community.qlik.com/t5/QlikView/How-to-get-year-in-sql/m-p/1119452#M904645 Colin-Albert 2016-07-08T12:56:32Z Re: How to get year in sql https://community.qlik.com/t5/QlikView/How-to-get-year-in-sql/m-p/1119453#M904646 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Getting below error.. pls suggest</P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/130687_Untitled.png" style="height: 207px; width: 620px;" /></P></BODY></HTML> Fri, 08 Jul 2016 13:01:19 GMT https://community.qlik.com/t5/QlikView/How-to-get-year-in-sql/m-p/1119453#M904646 abhaysingh 2016-07-08T13:01:19Z