Substring in Snowflake, string is the parameter value

154 Views Asked by At

SET Date = '050120';

select SUBSTR("+Parameters!Date.Value+", 5, 2) enter image description here

I am passing the Date parameter value. Why is it not picking the date value? It is showing the output as 'ra' which is shown in screen shot. I am expecting it to show 20.

1

There are 1 best solutions below

0
On

This will return 10:

SET Date = '050120';

select SUBSTR($Date , 5, 2);