I have source data loaded into an Oracle database. The fields I want to convert are defined as number(7) which are defined in my metadata as integers. The format of the date is YYYYDDD. What is the best way of converting them to dates in DataStage?
Thanks for all the help.
Converting integer to date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In a Transformer stage explore the conversion functions and the casting functions. You can also search the forum, since this question has been addressed in the recent past.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: