Illegal date/time value

[poorna_76]

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]")

Please help me out.

[davidnemirovsky]

Perhaps try using the DB2 native format: YYYY-MM-DD-HH.MI.SS.FFFFFF

Would look something like:
OCONV(ICONV(linkname.DATE1,"DMDY"),"D-YMD[4,4,2]") : "-00.00.00.000000"