how to convert date type(2008-03-12) to date type(12-MAR-08)

amreesh_singh · Post by **amreesh_singh** » Thu Sep 25, 2008 4:01 am

ArndW · 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 · 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 · 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".

ray.wurlod · 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]".

amreesh_singh · 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 · 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.