value of date parameter in OCI stage

[sachin1]

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.

[chulett]

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

Code: Select all

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