Issue with 'where' during Oracle Dev connection

[Asiolinka]

Hello,

I have an issue with date filter during connection with Oracle Dev database. 

Trying to put :

SELECT *
FROM "xyz"."database" where date = 'YY-MM-DD';

Tried to find any correct date format but still does not work.

Any ideas what should I do to filter base from connection level?

[Or]

Whatever you would have used on the database end - you should be able to copy your query from PL/SQL Developer or whatever other tool you use to query the Oracle DB.

[Mark_Little]

HI @Asiolinka 

Adding to what @Or has said, you are also assuming that the date column is being read by Qlik as date field, Maybe try formatting the DATE(Date)