I am having a SQL Server query with DATEDIFF function in it .
SELECT DATEDIFF(dd, mydate , GETDATE())
This query will extract the difference between the days of mydate and GETDATE() values .
Refer below link for DATEDIFF function on SQL Server
I tried to convert the query to Oracle and execute it .
But there is no DATEDIFF function in Oracle .
I tried using ROUND function like
SELECT ROUND(( (SYSDATE) - mydate ))
But of no use .
Kindly suggest me the equivalent for the SQL Server DATEDIFF function in Oracle