JDBC Prepared Statement . setDate(….) doesn’t save the time, just the date.. How can I save the time as well?

by

Instead of Date you should use a Timestamp and the setTimestamp method.

pratically you have to do something like that: 

private static java.sql.Timestamp getCurrentTimeStamp() {
    java.util.Date today = new java.util.Date();
    return new java.sql.Timestamp(today.getTime());
}

….

preparedStatement.setTimestamp(4,getCurrentTimeStamp());

More Related Contents:

  1. PreparedStatement IN clause alternatives?
  2. PreparedStatement with list of parameters in a IN clause [duplicate]
  3. Using setDate in PreparedStatement
  4. Java: Insert multiple rows into MySQL with PreparedStatement
  5. How can I get the SQL of a PreparedStatement?
  6. Using “like” wildcard in prepared statement
  7. Get query from java.sql.PreparedStatement [duplicate]
  8. How does a PreparedStatement avoid or prevent SQL injection?
  9. Variable column names using prepared statements
  10. Reusing a PreparedStatement multiple times
  11. Where’s my invalid character (ORA-00911)
  12. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  13. right syntax to use near ‘?’
  14. How does Java’s PreparedStatement work?
  15. Does the preparedStatement avoid SQL injection? [duplicate]
  16. mysql prepared statement error: MySQLSyntaxErrorException
  17. PreparedStatement setNull(..)
  18. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  19. How to use prepared statement for select query in Java?
  20. PreparedStatement and setTimestamp in oracle jdbc
  21. java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
  22. Handling MySQL datetimes and timestamps in Java
  23. Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?
  24. java.sql.SQLException: Column count doesn’t match value count at row 1
  25. How is driver class located in JDBC4
  26. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  27. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  28. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  29. Connection cannot be cast to oracle.jdbc.OracleConnection
  30. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR

Leave a Comment