user63898 user63898 - 1 year ago 196
Java Question

Java how to add seconds to timestamp

I fail to add seconds to Java Timestamp

I have this but it gives me the same date:

int sec = 600;

java.sql.Timestamp ts_from_ws = new java.sql.Timestamp(retry_date);
Calendar cal = Calendar.getInstance();
java.sql.Timestamp ts_new_date_ws = new java.sql.Timestamp(cal.getTime().getTime());

Answer Source

The code you've got works for me. As a short but complete program:

import java.util.*;
import java.sql.*;

public class Test {
    public static void main(String[] args) {
        long retryDate = System.currentTimeMillis();

        int sec = 600;

        Timestamp original = new Timestamp(retryDate);
        Calendar cal = Calendar.getInstance();
        cal.add(Calendar.SECOND, sec);
        Timestamp later = new Timestamp(cal.getTime().getTime());



2011-11-07 10:27:45.302
2011-11-07 10:37:45.302

Note the difference of 10 minutes, i.e. 600 seconds.

Of course you lose the sub-millisecond precision this way, which may well not be ideal - and it goes against what I'm normally use a timestamp for in the first place - but it does add the seconds...

Another option would be to just use Timestamp directly:

Timestamp original = ...;
Timestamp later = new Timestamp(original.getTime() + (sec * 1000L));
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download