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.
So, what's the function in Oracle
that would be the equivalent to DATEDIFF
in the SQL Server?
On Oracle, it is an arithmetic issue
select DATE1-DATE2 from dual
for the number of days.
Otherwise, multiply the value
Image: © Unsplash
- by 24 for hours
- by 1440 for minutes
- by 86400 for seconds