Datetime in java

Question

I have a JDBC current date and time insert into Mysql Database.

It submits the current date and a fixed time into the Mysql date type field as 2012/05/25 00:00:00. The date part works very fine but the time doesn't shows any value.

I'm inserting the value with the following code:

java.util.Date myDate = new java.util.Date();
java.sql.Date sqlDate = new java.sql.Date(myDate.getTime());
PreparedStatement PStmt = con.prepareStatement(Sql query);
PStmt.setDate(1,sqlDate);

Answer 1

Use java.sql.Timestamp instead of java.util.Date

For example if you are using PreparedStatement to handle your insert, you can pass your date as;

java.util.Date date = new Date();
pst.setTimestamp(columIndex, new java.sql.Timestamp(date.getTime()));

Answer 2

I think you need to have timestamp as column type in mysql.