Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QV variable with timestamp as default value

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

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

3 Replies
maxgro
MVP
MVP

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');

Not applicable
Author

Thanks, but I am getting below error

Ss.PNG

Not applicable
Author

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.