convert from char data type to date data type
Posted: Wed Feb 06, 2008 1:17 pm
Hi
In Source I have two columns one is eff_month, eff_year. those data type is char.
I want to load in target as due_date (data type date) as month/year.
I am doing concadination using to_date. in oracle it is working but in data stage I am getting error.
Can any one help me how to do this rek.
we are using 7.1 datastage
Thanks in Advance
In Source I have two columns one is eff_month, eff_year. those data type is char.
I want to load in target as due_date (data type date) as month/year.
I am doing concadination using to_date. in oracle it is working but in data stage I am getting error.
Can any one help me how to do this rek.
we are using 7.1 datastage
Thanks in Advance