Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
singbittoo
Creator
Creator

Issue with date filter using OLEDB connection for oracle

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 ?

Labels (4)
2 Replies
m_woolf
Master II
Master II

Probably needs the date in some specific format.

Maybe: '2018-12-01'

singbittoo
Creator
Creator
Author

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 ??