DATEDIFF function in Oracle?
Posted on 2011-02-23
I am connecting to an Oracle database via a linked server in sql server 2005.
There is a column in the Oracle database SCHEDULED_START_DATE that I want to use in the WHERE clause,
That is, return rows where the SCHEDULED_START_DATE is less than or equal to todays date.
In SQL Server I would use the following:
where datediff("dd",SCHEDULED_START_DATE , getdate()) <= 90
Is there an equivalent in Oracle?