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.
No I think you misunderstood the meaning of TIMESTAMP with Oracle in this case. With MySQL for example Timestamp column is just that a timestamp from the DB, nothing you can insert into, like an auto date column. In Oracle timestamp contains the date AND time in the field, where as the date field contains just the date.
R
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
