JDBC ResultSet getDate 丢失精度 [英] JDBC ResultSet getDate losing precision

问题描述

我在 ResultSet.getDate(x) 调用中失去了精度.基本上:

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

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

返回截断到 MODIFIED 是默认精度的 Oracle TIMESTAMP 字段的日期的日期.我认为可能缺少一些 JDBC 调整；通常 TIMESTAMP 与 DATE 兼容，但我希望我不必重新定义整个表.

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.

推荐答案

ResultSet.getDate() 返回一个 java.sql.Date，而不是 java.util.Date.它被定义为一个永恒的日期.如果您想要时间戳，请使用 <代码>ResultSet.getTimestamp()!

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()!

这篇关于JDBC ResultSet getDate 丢失精度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！