Page 1 of 1
how to convert date type(2008-03-12) to date type(12-MAR-08)
Posted: Thu Sep 25, 2008 4:01 am
by amreesh_singh
how to convert date type(2008-03-12) to date type(12-MAR-08)
Posted: Thu Sep 25, 2008 4:16 am
by ArndW
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]")
Posted: Thu Sep 25, 2008 4:26 am
by tennetiharika
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
Posted: Thu Sep 25, 2008 4:56 am
by ray.wurlod
But U did not ask the question.
The second person personal pronoun in its nominative form in English is spelled "you".
Posted: Thu Sep 25, 2008 4:58 am
by ray.wurlod
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]".
Posted: Thu Sep 25, 2008 5:21 am
by amreesh_singh
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
Posted: Thu Sep 25, 2008 6:21 am
by ray.wurlod
If you have a parallel job question please post it in the parallel job (Enterprise Edition) forum.