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.
AGAIN DATE CONVERSION
Moderators: chulett, rschirm, roy
Re: AGAIN DATE CONVERSION
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.sam334 wrote:So, M/DD/YYYY for January to September and then MM/DD/YYYY for Oct to Dec.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
http://www-01.ibm.com/support/knowledge ... rmats.html
and in an appendix in your Developer's Guide pdf.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers