This content has been marked as final. Show 2 replies
Can any one please help me on below requirement.
I have a oracle table like below in qlik
to_char(ap.date,'DD/MM/YYYY') as date,
from account ap
where to_char(ap.date,'DD/MM/YYYY') in '31/07/2017';
In the above table at where condition i have to apply where ap.date <= '31/07/2017' in static way dynamic method is not required.just for testing purpose.
Please help me how to write that oracle syntax at select statement.
Thanks in advance.