Ok, maybe I HAVE posted this to the list. (Mental note: don't send emails after lunch at the pub...)
Brendan ----- Original Message ----- From: "Joe Germuska" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Cc: "Brad Matlack" <[EMAIL PROTECTED]> Sent: Friday, February 20, 2004 10:41 AM Subject: Re: Oracle date tip > At 6:02 PM -0500 2/19/04, Andy Malakov wrote: > >Brad, > > > >I do not think it is OJB/JDBC problem. > > > >What is strange about your mail is the fact that NLS_DATE_FORMAT > >fixed the problem - instead of NLS_TIMESTAMP_FORMAT. Since you > >applied JavaDate2SqlTimes converter - all your dates at JDBC level > >should have been converted to java.sql.Timestamp. > > > >Please do not be confused by the way P6SPY displays generated JDBC > >query (it may be approximate). > > Oracle doesn't have a TIMESTAMP type; its "DATE" encompasses SQL > TIME, TIMESTAMP, and DATE. > > Joe > -- > Joe Germuska > [EMAIL PROTECTED] > http://blog.germuska.com > "Imagine if every Thursday your shoes exploded if you tied them > the usual way. This happens to us all the time with computers, and > nobody thinks of complaining." > -- Jef Raskin > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
