topic Re: Issue with date filter using OLEDB connection for oracle in QlikView

Issue with date filter using OLEDB connection for oracle

singbittoo — Sat, 16 Nov 2024 04:58:07 GMT

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 ?

Re: Issue with date filter using OLEDB connection for oracle

m_woolf — Thu, 13 Dec 2018 15:47:47 GMT

Probably needs the date in some specific format.

Maybe: '2018-12-01'

Re: Issue with date filter using OLEDB connection for oracle

singbittoo — Thu, 13 Dec 2018 15:50:25 GMT

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