Re: Date conversion from char(8) YYYYMMDD to a valid DB2 ISO representations (YYYY-MM-DD)

2011-01-11 Thread Shmuel Metz (Seymour J.)
In <476996cbbe9af14285e09e63c370072a14e32b8...@phxccrprd01.adprod.bmc.com>, on 01/10/2011 at 09:15 AM, "Blaicher, Chris" said: >Wrong forum. It's on topic for this mailing list. >You want the DB2-L forum. DB2-L is probably a more useful mailing list for the question, but it's legitimate her

Re: Date conversion from char(8) YYYYMMDD to a valid DB2 ISO representations (YYYY-MM-DD)

2011-01-10 Thread Blaicher, Chris
[mailto:ibm-m...@bama.ua.edu] On Behalf Of Paulo Roberto Leonardo Pereira Sent: Monday, January 10, 2011 8:01 AM To: IBM-MAIN@bama.ua.edu Subject: Date conversion from char(8) MMDD to a valid DB2 ISO representations (-MM-DD) Is there how to LOAD (through the LOAD utility) a date in CHAR(8

Date conversion from char(8) YYYYMMDD to a valid DB2 ISO representations (YYYY-MM-DD)

2011-01-10 Thread Paulo Roberto Leonardo Pereira
Is there how to LOAD (through the LOAD utility) a date in CHAR(8) containing MMDD to a DB2 ISO date in the format -MM-DD ? Thanks Paulo -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to list