In SQL server if you have columns which are of Date/Time type then sometimes you need to find their difference for passing into the application when needed. So for doing that SQL Server provides a ...

--DATEDIFF Function The DATEDIFF function returns the difference between two dates in terms of the specified date part (years, months, days, etc.).