DSXchange

Posted: **Tue Aug 14, 2007 9:39 am**

i have a question like i will use a parameter (date parameter or string parameter) having a values like '31/01/2007' 'DD/MM/YYYY' FORMAT for my job, can i use this parameter in my OCI stage for comparision with columns containing date values.

Posted: **Tue Aug 14, 2007 10:20 am**

Sure, just cast it TO_DATE using the proper matching mask:

Code: Select all

and X = TO_DATE('#YOUR_PARAM#','DD/MM/YYYY')

DSXchange

value of date parameter in OCI stage

value of date parameter in OCI stage