Iconv and Oconv Date Conversion

[tanmaya]

Hi,

I have a problem using the iconv and oconv fuctions for the date conversion in Datastage 8.0.1. The format that i entered the date was mm/dd/yyyy and the output desired was yyyy/mm/dd but i got an output of yyyy mm dd.How can i add the slash in my output.

And, i would also like to know how I could convert to date in the form of
yy MON dd.
The fuction that I used is as follows.

Oconv(Iconv(InputFieldName,"D DMY[2,2,4]"),"D YMD[4,2,2]")

Thanks in Advance

Regards,
Tanmaya

[ray.wurlod]

Welcome aboard. You specified space as the delimiter and that's what you got. What you needed was something like

Code: Select all

Oconv(Iconv(InputFieldName,"DMDY"),"D/YMD[4,2,2]") 

You might find this article informative.

For the second question, try

Code: Select all

Oconv(Iconv(InputFieldName,"DMDY"),"D YMD[2,A3,2]") 

[sachin1]

Oconv(Iconv("06/17/2009" ,"D MDY[2,2,4]"),"D/YMD[4,2,2]") gives the output 2009/06/17.

[ray.wurlod]

... the output desired was yyyy/mm/dd

[tanmaya]

Welcome aboard. You specified space as the delimiter and that's what you got. What you needed was something like

Code: Select all

Oconv(Iconv(InputFieldName,"DMDY"),"D/YMD[4,2,2]") 

You might find this article informative.

For the second question, try

Code: Select all

Oconv(Iconv(InputFieldName,"DMDY"),"D YMD[2,A3,2]") 

Thank you Ray, that surely worked.

Regards,

Tanmaya

[chulett]

Then time to mark your topic as Resolved using the button at the top of the page!