Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 10g returns DATE as java.sql.Date?

Oracle 10g returns DATE as java.sql.Date?

From: <thomas_okken_at_hotmail.com>
Date: 9 Nov 2005 11:08:50 -0800
Message-ID: <1131563329.893881.223050@g43g2000cwa.googlegroups.com>


I noticed that Oracle 10g XE, with the ojdbc14.jar JDBC driver, returns DATE columns as java.sql.Date valuess. That surprised me, because the ResultSetMetaData claims the column's Java type is java.sql.Timestamp -- which would make more sense since DATE columns contain date *and* time information, just just date.
I seem to remember that Oracle 8i did return java.sql.Timestamp for DATE columns.
Did they change this, or am I just misremembering? Is there a way to get the driver to return java.sql.Timestamp? Received on Wed Nov 09 2005 - 13:08:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US