A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)

by

The java.sql package has three date/time types:

You want the last one: java.sql.Timestamp.

If you are using these types, you don’t need to call a specific setter; just use:

java.util.Date date = new Date();
Object param = new java.sql.Timestamp(date.getTime());
// The JDBC driver knows what to do with a java.sql type:
preparedStatement.setObject(param);

More Related Contents:

  1. Hours and seconds are lost when storing a date in the database [closed]
  2. Multiple queries executed in java in single statement
  3. java.util.Date vs java.sql.Date
  4. MySQL and JDBC with rewriteBatchedStatements=true
  5. right syntax to use near ‘?’
  6. Running a .sql script using MySQL with JDBC
  7. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  8. How to use prepared statement for select query in Java?
  9. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  10. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  11. Cannot issue data manipulation statements with executeQuery()
  12. Java JDBC Access denied for user [closed]
  13. Getting output from dbms_output.get_lines using JDBC
  14. Java – Can’t use ResultSet after connection close
  15. Timezones in SQL DATE vs java.sql.Date
  16. SQL prepared statement how to select via multiple possible menu selections?
  17. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  18. JDBC returning MySQLSyntaxError Exception with correct statement
  19. Problems reading/writing UTF-8 data in MySQL from Java using JDBC connector 5.1
  20. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  21. MySQL connector error “The server time zone value Central European Time” [duplicate]
  22. com.mysql.jdbc.PacketTooBigException
  23. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server [duplicate]
  24. Should a database connection stay open all the time or only be opened when needed?
  25. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  26. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  27. JDBC MySQL connection using Unix Socket
  28. JDBC connection error : unrecognized timezone [duplicate]
  29. Searching between dates in SQL with JDBC?
  30. Getting last record from mysql

Leave a Comment