Hi,
I am trying to insert date values into db2 table
which is defined as date(10).
I tried using both ODBC & DB2UDB stage.
When i use ODBC stage, iam getting the following error:
Illegal date/time value DATE1 = '01/01/2004'
When i use DB2UDB stage, iam getting the following error:
" Value treated as NULL
Attempt to convert String value "01/01/2004" to Date type unsuccessful "
I am using folowing code to convert into db2 format:
OCONV(ICONV(linkname.DATE1,"DMDY"),"D4/MDY[2,2,4]")
I tried inserting the Date value in all the possible DB2 formats,
by changing ICONV/OCONV formats,but no use.
Please help me out.
Convert String to Date
Moderators: chulett, rschirm, roy
Re: Convert String to Date
You could use the transform DateGenericToODBC to convert your date into an ODBC format or maybe use something similar to to thisI am using folowing code to convert into db2 format:
OCONV(ICONV(linkname.DATE1,"DMDY"),"D4/MDY[2,2,4]")
I tried inserting the Date value in all the possible DB2 formats,
by changing ICONV/OCONV formats,but no use.
Code: Select all
OCONV(ICONV(linkname.DATE1,"DMDY"),"D-YMD[4,2,2]")