Executing a Query with a Date in the Where Clause Returns No Rows Using the Oracle Provider for OLEDB with Linked Server in SQL Server 2005 and an Oracle Database
(Doc ID 782761.1)
Last updated on FEBRUARY 15, 2019
Applies to:Oracle Provider for OLE DB - Version 18.104.22.168 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
Microsoft Windows Itanium (64-bit)
*** Checked for relevance on 10-Jul-2017 ***
Executing a Query with a date in the where clause returns no rows using the Oracle Provider for OLEDB with Linked Server in SQL Server 2005 and an Oracle Database. The same query returns 28 rows with the MS OLEDB Provider.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document