fix: ResultSet.getDate is often wrong as it fetches day-precision times

[gigi.git] / src / org / cacert / gigi / dbObjects / Certificate.java

diff --git a/src/org/cacert/gigi/dbObjects/Certificate.java b/src/org/cacert/gigi/dbObjects/Certificate.java
index 275aa20e127db2eaec23738e45d8815101c90e74..2aecedf75e295f4a6af95fec61af7006bfafd3ac 100644 (file)
--- a/src/org/cacert/gigi/dbObjects/Certificate.java
+++ b/src/org/cacert/gigi/dbObjects/Certificate.java
@@ -471,7 +471,7 @@ public class Certificate implements IdCachable {
                 prep.setInt(1, getId());
                 GigiResultSet res = prep.executeQuery();
                 if (res.next()) {
                 prep.setInt(1, getId());
                 GigiResultSet res = prep.executeQuery();
                 if (res.next()) {

-                    return new java.util.Date(res.getDate("revoked").getTime());
+                    return new java.util.Date(res.getTimestamp("revoked").getTime());

                 }
             }
         }
                 }
             }
         }