I’m trying to run a query that contains substitution variables and, unlike previous versions, I can’t tell it what kind of data type I want to use. In previous versions, the window where you enter the variable value allowed you to select the data type. This option is no longer there. This is causing a problem because I keep getting no data returned for my query.
This is as designed. For a workaround, include the to_date function inside the substitution window. So when prompted for the variable value, enter something like to_date('12/27/2004','mm/dd/yyyy').
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center