Insert current date and time using java.util.Date object in MySQL

Question

I have a field in MySQL created_on with datatype DATETIME. For that field, I have to insert the current date and time. I have taken java.util.Date object.

Date dateobj = new Date()
String query = "insert into users(created_on) values(?)";
ps = con.prepareStatement(query);
ps.setDate(1, new java.sql.Date(dateobj.getTime()));
insert_flag=ps.executeUpdate();

The query is executing fine but it is inserting only current date with 00:00:00. I want current date and time (example: 2015-10-28 03:23:50)

Tunaki · Accepted Answer · 2015-10-28 10:08:42Z

1

To insert a date and a time, you need to use setTimestamp instead of setDate and the datatype of your database column must be DATETIME (or TIMESTAMP).

Quoting setDate Javadoc:

The driver converts this to an SQL DATE value when it sends it to the database.

and quoting MySQL documentation:

The DATE type is used for values with a date part but no time part.

Working code:

ps.setTimestamp(1, new java.sql.Timestamp(new Date().getTime()));

edited Oct 28, 2015 at 10:08

answered Oct 28, 2015 at 9:59

Tunaki

138k46 gold badges370 silver badges443 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert current date and time using java.util.Date object in MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related