Using timestamp with mysql and java

Question

I'm trying to save a timestamp to a table in mySQL but whenever I look at the results it just shows 0000-00-00 00:00:00.

I assume I'm not using the timestamp right but anyways in my table I have a column named time and its property is TIMESTAMP

In my Java I have:

java.sql.Timestamp timestamp = new java.sql.Timestamp(0);

String query = "insert ignore into time(time_now) values (?)";

pstmt.setString(1, timestamp);
pstmt.executeUpdate();

My database connection is fine as I have a lot of other information that's being uploaded to it with no problem, I'm just having trouble with the timestamp

Firsr you should use datetime instead and second - what is the format of the date you want to insert? It should be yyyy-MM-dd HH:mm:ss — juergen d
– juergen d, Commented Mar 18, 2015 at 23:07
Well essentially I need just hh:mm:ss but TIMESTAMP in mysql forces date. If there's a better way to save just time I'd appreciate it. — Mr.Smithyyy
– Mr.Smithyyy, Commented Mar 18, 2015 at 23:09

Dermot Blair · Accepted Answer · 2015-03-18 23:05:35Z

1

Something like this should work:

java.util.Date date = new java.util.Date();
Timestamp timestamp = new Timestamp(date.getTime());
preparedStatement = connection.prepareStatement("insert ignore into time(time_now) values (?)");
preparedStatement.setTimestamp(1, timestamp);

answered Mar 18, 2015 at 23:05

Dermot Blair

1,62011 silver badges10 bronze badges

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

Comments

juergen d · Accepted Answer · 2015-03-18 23:26:50Z

1

If you only want to store the time then use the TIME data type instead and to insert the current time of the SQL server use CURTIME() like this

 insert into your_table (time_column) 
 values (curtime())

edited Mar 18, 2015 at 23:26

answered Mar 18, 2015 at 23:15

juergen d

205k40 gold badges303 silver badges377 bronze badges

Comments

eera · Accepted Answer · 2015-03-18 23:09:03Z

0

Take a look at java.sql.Timestamp. You are instantiating a new Timestamp object with '0'.

answered Mar 18, 2015 at 23:09

eera

213 bronze badges

2 Comments

Mr.Smithyyy Over a year ago

I tried adding the ints but it Eclipse would not accept it, only 0 passed without errors so I must be doing something else wrong.

eera Over a year ago

It takes a long not an int in the constructor (Note: not a Long object type).

Collectives™ on Stack Overflow

Using timestamp with mysql and java

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related