convert from char data type to date data type

[deva]

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

[paddu]

I am doing concadination using to_date. in oracle it is working but in data stage I am getting error.

Did you try inserting into due_date field in Toad or anyother query tool you have using to_date function. Did the field accept???

[deva]

I got the answer we have to use
Oconv(Iconv(Fac_in.COLL_EFFEC_MO: Fac_in.COLL_EFFEC_YR, "D YM"), "D4/")

[ray.wurlod]

You got AN answer. Care to mark the thread as Resolved?