How to convert String MMDDYYYY to Db2 date MM/DD/YYYY

vinothkumar · Post by **vinothkumar** » Wed Dec 15, 2010 11:01 am

Try this :
OConv(IConv(StageVar1[1,2]:'/':StageVar1[3,2]:'/':StageVar1[5,4], "D2/"),"D4/")

Where StageVar1 is your date '19991231'

vinothkumar · Post by **vinothkumar** » Wed Dec 15, 2010 11:06 am

Sorry the date should be MMDDYYYY format

svhari76 · Post by **svhari76** » Wed Dec 15, 2010 11:26 am

My input date is 11302009
and tried your suggestion above and getting NULL as return

vinothkumar · Post by **vinothkumar** » Wed Dec 15, 2010 12:38 pm

What's your target datatype. It should be a DATE.

gateleys · Post by **gateleys** » Wed Dec 15, 2010 12:43 pm

svhari76 wrote:Hi

How can i convert String MMDDYYYY to Db2 date MM/DD/YYYY ?

Eg: '11302009' to be 11/30/2009

Try-

Oconv(Iconv(InLink.YourDate, "DMDY[2,2,4]"), "D/MDY[2,2,4]")

chulett · Post by **chulett** » Wed Dec 15, 2010 12:57 pm

I seem to recall the DB2 stage wanting dates in internal format...

svhari76 · Post by **svhari76** » Wed Dec 15, 2010 2:09 pm

I Tried this and still gets the NULL.

Oconv(Iconv(Input.LCL_DPTR_DTE, "DMDY[2,2,4]"), "D/MDY[2,2,4]")

ray.wurlod · Post by **ray.wurlod** » Wed Dec 15, 2010 5:02 pm

Leave off the Oconv() function. DB2 stage wants internal format.

DSXchange