DATEDIFF is a common function in the SQL Server to find the number of days between two dates. Oracle offers its own solution, although does not have the DATEDIFF function.

DATEDIFF (SSIS Expression) [!INCLUDE sqlserver-ssis] Returns the number of date and time boundaries crossed between two specified dates. The datepart parameter identifies which date and time ...

This SQL code declares two variables: @startdate and @enddate, and sets their values to '12/4/2017' and '1/16/2018', respectively. The SELECT statement then uses the DATEDIFF function to calculate the ...