DSXchange

All, Need a help again in date conversion. I have a parallel job which reads CSV file in sequential file stage. Now, in server job it is working fine but in parallel SEQ, giving lots of trouble.

Have an input column (Varchar), data looks like. 7/14/2014 and 10/28/2013 and so on. So, M/DD/YYYY for January to September and then MM/DD/YYYY for Oct to Dec.

Output is DB2 with DATE data type.

Very much confused how to convert it. Any help.

sam334 wrote:So, M/DD/YYYY for January to September and then MM/DD/YYYY for Oct to Dec.

No, actually that's just for former. It means it can have single digit months (1/2/3 rather than 01/02/03) not that they all are somehow.

ps. Date, Time and Timestamp formats are listed here (copy the whole string, the forum software doesn't like the URL for some reason):

http://www-01.ibm.com/support/knowledge ... rmats.html

and in an appendix in your Developer's Guide pdf.

Okay Thanks Craig.Looking it now.