I tried an example from w3schools (https://www.w3schools.com/sql/trysqlserver.asp?filename=trysql_func_sqlserver_datediff) and tried to convert and I got an error, here's the query: SELECT DATEDIFF(year, '2017/08/25', '2011/08/25') AS DateDiff;
I tried an example from w3schools (https://www.w3schools.com/sql/trysqlserver.asp?filename=trysql_func_sqlserver_datediff) and tried to convert and I got an error, here's the query:
SELECT DATEDIFF(year, '2017/08/25', '2011/08/25') AS DateDiff;