value of date parameter in OCI stage
Moderators: chulett, rschirm, roy
value of date parameter in OCI stage
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.
Sure, just cast it TO_DATE using the proper matching mask:
Code: Select all
and X = TO_DATE('#YOUR_PARAM#','DD/MM/YYYY')
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers