How to store Java Date to Mysql datetime with JPA

by

see in the link :

http://www.coderanch.com/t/304851/JDBC/java/Java-date-MySQL-date-conversion

The following code just solved the problem:

java.util.Date dt = new java.util.Date();

java.text.SimpleDateFormat sdf = 
     new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

String currentTime = sdf.format(dt);

This ‘currentTime‘ was inserted into the column whose type was DateTime and it was successful.

More Related Contents:

  1. How to store date/time and timestamps in UTC time zone with JPA and Hibernate
  2. Connection to Db dies after >4
  3. How to annotate MYSQL autoincrement field with JPA annotations
  4. Hibernate: Automatically creating/updating the db tables based on entity classes
  5. No Dialect mapping for JDBC type: 1111
  6. @GeneratedValue polymorphic abstract superclass over MySQL
  7. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  8. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  9. Hibernate: Create Mysql InnoDB tables instead of MyISAM
  10. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  11. How to use Spring Boot with MySQL database and JPA?
  12. Is java.sql.Timestamp timezone specific?
  13. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  14. Hibernate Annotations – Which is better, field or property access?
  15. What is this spring.jpa.open-in-view=true property in Spring Boot?
  16. “EEE MMM dd HH:mm:ss ZZZ yyyy” date format to java.sql.Date
  17. How to calculate elapsed time from now with Joda-Time?
  18. Setting default values for columns in JPA
  19. Transaction marked as rollback only: How do I find the cause
  20. Can’t parse String to LocalDate (Java 8)
  21. Passing parameters to a JDBC PreparedStatement
  22. Should JPA Entity Manager be closed?
  23. UNION to JPA Query
  24. @BatchSize a smart or stupid use?
  25. Error creating bean with name ‘entityManagerFactory
  26. Name attribute in @Entity and @Table
  27. JPA: Override Auto generated ID [duplicate]
  28. A persistent connection with JDBC to MySQL
  29. javax.persistence.TransactionRequiredException in small facelet application
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment