Problem converting date formats
Posted: Thu Aug 06, 2009 8:30 pm
Friends,
I'm trying to create a new job which parses a Sequential file and populates a staging table.
The problem is with one of the date columns present in the file. The format of the data is "Jul 31 2009" (MM DD YYYY) whereas the DataStage function ICONV expects it in "DD MM YYYY".
How can I convert this format so that I can populate the table
Thanks
Yamini
I'm trying to create a new job which parses a Sequential file and populates a staging table.
The problem is with one of the date columns present in the file. The format of the data is "Jul 31 2009" (MM DD YYYY) whereas the DataStage function ICONV expects it in "DD MM YYYY".
How can I convert this format so that I can populate the table
Thanks
Yamini