Date issue in where clause in SQL statement in Qlikview
I am creating a table in qlikview using sql query. Query works fine in SQL returns records (Oracle Database) but the same query returns zero records in Qlikview. I am using variable to get '30-JUN-15' this value but it was not returning anything so tried using hard code value but still the same problem.
SQL Select * from xyx where TDTIME='30-JUN-15';
I tried changing date formats but its not working. I dont want to use script like as i already have huge data set.