How to update MySQL timestamp column using PreparedStatement in Java?

Question

I have created a table as below:

create table sample(id int not null,created_at timestamp,updated_at timestamp,name varchar(100),primary key(id));

I have tried to update the column in different ways as below, but am not able to update the time:

Calendar calender = Calendar.getInstance();
java.util.Date now = calender.getTime();
java.sql.Timestamp updatedAt = new java.sql.Timestamp(now.getTime());
stmt.setTimestamp(2, updatedAt);

java.sql.Timestamp  updatedAt = new java.sql.Timestamp(new java.util.Date().getTime());
stmt.setTimestamp(2, updatedAt);
    
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date date = new Date();
String updatedAt =sdf.format(date);
stmt.setString(2, updatedAt);

final java.util.Date updatedAt = new java.util.Date(System.currentTimeMillis());
stmt.setDate(2, new java.sql.Date(updatedAt.getTime()));

Please, help me to resolve this issue?

unable to update the time in database table , it is updating like 2014-07-29 00:00:00 — Haritha R
– Haritha R, Commented Jul 30, 2014 at 7:09

Roman C · Accepted Answer · 2014-07-30 08:07:30Z

2

The java.sql.Date() strips time portion of your date due to SQL convention. You can check SQL-92 standard.

Timestamp updatedAt = new Timestamp(Calendar.getInstance().getTimeInMillis());
stmt.setTimestamp(2, updatedAt);

edited Jul 30, 2014 at 8:07

answered Jul 30, 2014 at 7:13

Roman C

1

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

10 Comments

Scary Wombat Over a year ago

according to his code java.sql.Timestamp updatedAt = new java.sql.Timestamp(now.getTime()); stmt.setTimestamp(2, updatedAt); he already does

Scary Wombat Over a year ago

also according to javadoc sql.Date is A thin wrapper around a millisecond value that allows JDBC to identify this as an SQL DATE value

Roman C Over a year ago

@ScaryWombat His code is wrong, and it didn't used milliseconds to create a timestamp.

Haritha R Over a year ago

Yes @Scary Wombat have already tried the above code but as date is having milliseconds we are unable to update the column

Scary Wombat Over a year ago

@RomanC java.util.Date now Date.getime () returns millseconds

|

Collectives™ on Stack Overflow

How to update MySQL timestamp column using PreparedStatement in Java?

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related