Returns the number of date and time boundaries crossed between two specified dates. The datepart parameter identifies which date and time boundaries to compare. DATEDIFF returns a null result if any ...
select id, firstname,lastname,DepartmentName,Salary,Salary * 1.15 as incrementedSalary,HireDate,datediff(YEAR,HireDAate,'2020-12-31') from employe ...