Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
amreesh_singh
Participant
Posts: 15 Joined: Tue Aug 26, 2008 5:07 am
Post
by amreesh_singh » Thu Sep 25, 2008 4:01 am
how to convert date type(2008-03-12) to date type(12-MAR-08)
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Thu Sep 25, 2008 4:16 am
You need to convert it into internal format first, using ICONV(In.Column,"D4YMD") and then you convert it back into display format using something like OCONV(InternalDate,"D2DMY[2,3,2]")
tennetiharika
Participant
Posts: 11 Joined: Mon Feb 25, 2008 5:53 am
Location: Hyderabad
Post
by tennetiharika » Thu Sep 25, 2008 4:26 am
which ever format u want to convert it into.go through the help in data stage.Type ICONV and OCONV u will find solution for all date conversions
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Sep 25, 2008 4:56 am
But U did not ask the question.
The second person personal pronoun in its nominative form in English is spelled "you".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Sep 25, 2008 4:58 am
The Oconv() that Arnd gave you won't give quite the result you seek. Its second argument needs to be "D2-DMBY" or "D-DMY[2,3A,2]".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
amreesh_singh
Participant
Posts: 15 Joined: Tue Aug 26, 2008 5:07 am
Post
by amreesh_singh » Thu Sep 25, 2008 5:21 am
ray.wurlod wrote: The Oconv() that Arnd gave you won't give quite the result you seek. Its second argument needs to be "D2-DMBY" or "D-DMY[2,3A,2]". ...
Thanks for suggestion, How to use Iconv() and Oconv() functions in parallel jobs . If we cant use then wht's the other solution for the problem
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Sep 25, 2008 6:21 am
If you have a parallel job question please post it in the parallel job (Enterprise Edition) forum.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.