I am updating an ORACLE 8i table with where date = date
Incoming date field is selected in the format
Code: Select all
TO_CHAR(DATEfield,'YYYY-MM-DD HH24:MI:SS')
Then I am using ICONV/OCONV Combo to get this date format in a stage variable
Code: Select all
Oconv(Iconv(Left(Link1.DATEfield,10), "D-YMD"), "D-DMY[2,A3,2]")
i am updating the table with user-defined query
Code: Select all
UPDATE table SET field6=:6,field7=:7 WHERE field1=:1 AND field2=:2 AND field3=:3 AND field4=:4 AND field5=TO_DATE(:5, 'DD-MON-YY')
Code: Select all
NumDt.JoinTables1: At row 50, link "DSLink98", while processing column "DATEfield"
Value treated as NULL
Attempt to convert String value "05-JAN-04" to Date type unsuccessful
Kishan