JDBC ResultSet getDate losing precision

java oracle date jdbc resultset
orbfish picture orbfish · Jul 16, 2010 · Viewed 23.9k times · Source

I am losing precision in my ResultSet.getDate(x) calls. Basically:

rs = ps.executeQuery();
rs.getDate("MODIFIED");

is returning dates truncated to the day where MODIFIED is an Oracle TIMESTAMP field of default precision. I think there may be some JDBC tweak I'm missing; usually TIMESTAMP is compatible with DATE, but I'm hoping I don't have to redefine the entire table.

Answer

Affe picture Affe · Jul 16, 2010

ResultSet.getDate() returns a java.sql.Date, not a java.util.Date. It is defined to be a timeless date. If you want a timestamp, use ResultSet.getTimestamp()!

Related questions

Is java.sql.Timestamp timezone specific?

I have to store UTC dateTime in DB. I have converted the dateTime given in specific timezone to UTC. for that I followed the below code. My input dateTime is "20121225 10:00:00 Z" timezone is "Asia/Calcutta" My Server/DB(oracle) is …

Read More
Oracle SQL DATE conversion problem using iBATIS via Java JDBC

I'm currently wrestling with an Oracle SQL DATE conversion problem using iBATIS from Java. Am using the Oracle JDBC thin driver ojdbc14 version 10.2.0.4.0. iBATIS version 2.3.2. Java 1.6.0_10-rc2-b32. The problem revolves around a column of DATE type that is being …

Read More
JDBC - ORA-01861: literal does not match format string 01861

I have problem with retrieving a data from oracle data base I want to access data by using two JDatechoosers... I use JDatechooser to store date value in database of type date. chooser=new JDateChooser(); chooser.setBounds (200, 175, 175, 25); chooser.setDateFormatString("dd-MM-yyyy"); …

Read More