DSXchange

All,
Need a help in date conversion. I searched quite a bit but could not find the specific conversion function.

My input is from DB2 and data type is DATE which is YYYY-MM-DD for format. The output is in sequential file (.txt) and it needs to be MM/DD/YYYY format.

I used the below function, but not working.

Oconv(Iconv(As_Of_Dt,"D-MDY[2,2,4]","D/MDY[2,2,4]")

Any help.

Thanks.

Hopefully your target field is a string. True DATE data types are just an internal number and thus have no format so I do believe you can skip the IConv and try it with the OConv alone. Either that or leverage whatever DB2 uses for a "to char" function directly in the source SQL.

Craig. Thanks. My membership is still inactive though renewed last week, unlock it for few minutes would be great

If the source is in YMD order, then your Iconv() function must also specify YMD order. Yours specifies MDY order.

Try

See also Date Conversion Demystified

Ray, Thanks. as I posted earlier. My premium membership got expired and already renew in process. Can't see the code. Unlocking the code for a while would be really helpful.

It worked......Thanks Craig and Ray..