Having problems inserting a datetime value into an Oracle timestamp datatype.
Getting an Oracle error,
"1830: date format picture ends before converting entire input string"
I assumed that ND was doing the to_date conversions. Apparently, I am wrong.
Anyone conquered this CSpdatetime/Oracle issue?
Code example:
...
CSpMultiSQL idpDO = (CSpMultiSQL) CSpider.getDataObject("idpAdmin");
CSpTransaction theTrans = new CSpTransaction();
..
String dateStr = getDisplayFieldValue("txStartDate").stringValue();
String timeStr = getDisplayFieldValue("cbStartTime").stringValue();
String timestampStr = new String(dateStr + " " + timeStr);
CSpDatetime theTS = new CSpDatetime();
try
{theTS = new CSpDatetime(timestampStr);}
catch (CSpDatetimeParsingException ex)
..
idpDO.setValue("LOAD_IDP_LOAD_DATE", theTS);
..
theTrans.addDataObject (idpDO
,idpDO.constructDefaultInsertDBRequest()
);
command = theTrans.execute();
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
