Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a variable assigned to an inputbox, and in that the default value is timestamp(today(), 'YYYY-MM-DD HH:MM:SS'). when i try to pass this variable in my sql's where clause as a parameter it give me different sorts of errors and doesnt like it.
like: a non-numeric character was found where a numeric was expected
Can you please help me out here as to how do i pass the right values.
Database is an Oracle R12.
Thanks
Hi All,
I was able to resolve the issue by assigning the value to the variable in the script rather than in the input box.
Thanks all.
if your Qlik variable is vVar ( with this format YYYY-MM-DD HH:MM:SS)
in Oracle you can filter in this way (replace DATE with your Oracle field)
WHERE DATE > to_date('$(vVar)', 'YYYY-MM-DD HH:MI:SS');
Thanks, but I am getting below error
Hi All,
I was able to resolve the issue by assigning the value to the variable in the script rather than in the input box.
Thanks all.