Hi all,,
I am loading data from an oracle table to another oracle table...
For date , i am using the derivation as:
If Trim(DSLink21.WORK_ORDER_CRE_DT) = '' Then @NULL Else oconv(Iconv(DSLink21.WORK_ORDER_CRE_DT,"D"),"D-YMD[4,2,2]") : " " : " "
It gives me the error:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0...
Why is that so??? Looking at my data in the source, I cannot see anything wrong ..
can someone suggest whats going on...
Thanks...
DateTime error
Moderators: chulett, rschirm, roy
Simplest thing to do is replace your target Oracle stage with a Sequential File stage and write things out to a flat file. What does it look like there?
Keep working the job until the output looks correct, then hook the OCI stage back up.
ps. I personally find it "best" to work with Oracle dates as Timestamps in DataStage. You then explicitly control the time portions of the dates, setting them to all zeroes if required.
Keep working the job until the output looks correct, then hook the OCI stage back up.
ps. I personally find it "best" to work with Oracle dates as Timestamps in DataStage. You then explicitly control the time portions of the dates, setting them to all zeroes if required.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers