Issue with date filter using OLEDB connection for oracle

[singbittoo]

SELECT *
FROM some_table
Where Date>'01-DEC-18' and some other conditions;

i have the above query, when using ODBC connection its working fine and i am getting the required data all the filters are working fine, but when i am using OLEDB connection the date filter is not working but other filters are working and its loading all the data present in the database for the other filters, any idea what is happening ?

[m_woolf]

Probably needs the date in some specific format.

Maybe: '2018-12-01'

[singbittoo]

i am running the exact query with ODBC connection, i am running the exact query in Oracle SQl Developer its working fine there, is there any thing with OLEDB that we need to change the date format ??