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.

However, I will so to those of you who said Oracle is easier to admin that SQL, you’re just crazy. You’ve clearly never had to manage tablespaces in Oracle before.