1 files changed, 12 insertions, 0 deletions
diff --git a/src/database/NamedPreparedStatement.java b/src/database/NamedPreparedStatement.java
index f635891..398ef60 100644
--- a/src/database/NamedPreparedStatement.java
+++ b/src/database/NamedPreparedStatement.java
@@ -3,10 +3,14 @@ package database;
 import java.sql.Connection;
 import java.sql.PreparedStatement;
 import java.sql.SQLException;
+import java.sql.Timestamp;
 import java.util.ArrayList;
+import java.util.Calendar;
 import java.util.List;
+import java.util.Locale;
 import java.util.regex.Matcher;
 import java.util.regex.Pattern;
+import org.joda.time.DateTime;
 
 /**
  * Allows a prepared statement to contain named parameters instead of a question
@@ -64,6 +68,14 @@ public class NamedPreparedStatement {
         }
     }
 
+    public void setTimestamp(String name, DateTime dt) throws SQLException {
+        for (int paramIndex : getParamIndices(name)) {
+            Timestamp tsp = new Timestamp(dt.getMillis());
+            Calendar calendar = dt.toCalendar(Locale.ENGLISH);
+            stmt.setTimestamp(paramIndex, tsp, calendar);
+        }
+    }
+
     public PreparedStatement getStmt() {
         return stmt;
     }