> So, what's different between the ones that yield the correct values > and the ones that don't?
Please look at the values: 2009-04-15 00:00:00->2009-04-15 01:00:00.0
The value I inserted in table was 2009-04-15 00:00:00 and from rs.getString(1) I got the same value. rs.getTimestamp(1) returned me a different value (note the hour value is 1 instead of 0). The value I got is: 2009-04-15 00:00:00
> If you can put together a self-contained test case that someone can > compile and run on their own machine, it becomes much easier for > others to understand the problem and to help.
I did so. Please read the following portion carefully:
Statement stmt = con.createStatement(); stmt.executeUpdate("create table ts_test(a timestamp)"); stmt.executeUpdate("insert into ts_test values('15-APR-09');"); ResultSet rs = stmt.executeQuery("select * from ts_test"); while (rs.next()) { Timestamp t = rs.getTimestamp(1); System.out.println(rs.getString(1)+"->"+ t); } stmt.executeUpdate("drop table ts_test");