> I assumed that ND was doing the to_date conversions.
> Apparently, I am wrong.
AFAIK, ND does a fairly decent to_date() conversion when you use date
fields. The error message you are getting seems to be a clear indication of
ND attempting a TO_DATE(), but there being some mismatch between the format
string and the value string.
I would turn the TERSE_DEBUG ON on the RDBMS service and look at the log to
see what SQL is finally going to Oracle.
Aby
TeamND
> -----Original Message-----
> From: scott johnson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 15, 1999 1:33 PM
> To: [EMAIL PROTECTED]
> Subject: [ND] Help with Oracle RDBMS/CSpDatetime usage
>
>
>
> 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]
>
_________________________________________________________________________
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]
