Mystery resolved. Thanks, Brendan.
> -----Original Message-----
> From: Brendan Johnston [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 16, 1999 12:57 PM
> To: 'Aby Mathew'; 'Scott Johnson';
> '[EMAIL PROTECTED]'
> Subject: RE: [ND] Help with Oracle RDBMS/CSpDatetime usage
>
>
> Scott, Aby,
>
> TO_DATE is the oracle date format.
> {ts ... is the ODBC date format
>
> Scott is using an ODBC driver to access Oracle.
> I suggest switching to the native driver.
>
> Brendan
>
>
> -----Original Message-----
> From: Aby Mathew [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 16, 1999 11:59 AM
> To: 'Scott Johnson';
> '[EMAIL PROTECTED]'
> Subject: Re: [ND] Help with Oracle
> RDBMS/CSpDatetime
> usage
>
> Scott,
>
> When I look at the RBBMS Service log, for a date field I
> find something like
> this:
>
> >> TO_DATE('1999/12/15 00:00:00','YYYY/MM/DD
> HH24:MI:SS') <<
>
> Yes, ND creates this TO_DATE() with matching format and
> value strings. I am
> confused by what I see in your log :
>
> >> {ts '1999-12-15 00:00:00.000'} <<
>
> I don't know what if means. Probably would require some
> investigation.
>
> Aby
>
_________________________________________________________________________
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]
