Java: How to add seconds to Timestamp?

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.setTimeInMillis(original.getTime());
        cal.add(Calendar.SECOND, sec);
        Timestamp later = new Timestamp(cal.getTime().getTime());

        System.out.println(original);
        System.out.println(later);
    }
}

Output:

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));
later.setNanos(original.getNanos());

I've always favoured brevity:

int sec = 600;

Timestamp later = new Timestamp(retry_date.getTime() + sec * 1000);

or if you want relative to "now":

Timestamp later = new Timestamp(System.currentTimeMillis() + sec * 1000);

Tags:

Java

Timestamp