string YYYYMMDD to DB2 date column

[puli.reddy]

Hi All,

I am trying to convert string values to date, but the job is being failed to convert string to date when I was trying with Iconv function with the same string format.
I changed the structure to DD/MM/YYYY then I used Iconv(StrCol,"D/E")
still it is being failed.
Anyone can suggest me to be succeeded the job in loading date column values.

Thanks in advance.

[ray.wurlod]

Try Iconv(StrCol, "DDMY")

[puli.reddy]

Thanks allot, It works well .

I tried it earlier, but problem with formatting data into DD/MM/YYYY only.

After saw you reply I thought to ensure the formatted data and I found while ensuring I had done wrongly.