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
convert from char data type to date data type
Moderators: chulett, rschirm, roy
Re: convert from char data type to date data type
deva wrote: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???
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: