> Oracle doesn't have a TIMESTAMP type; its "DATE" encompasses SQL > TIME, TIMESTAMP, and DATE.
What do you mean? http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements2a.htm#54201 http://www.databasejournal.com/features/oracle/article.php/2234501 ----- Original Message ----- From: "Joe Germuska" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Cc: "Brad Matlack" <[EMAIL PROTECTED]> Sent: Thursday, February 19, 2004 6:41 PM 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]
