How to remove sub seconds part of Date object

Question

java.util.Date gets stored as 2010-09-03 15:33:22.246 when the SQL data type is timestamp, how do I set the sub seconds to zero (e.g. 246 in this case) prior to storing the record.

Answer 1

The simplest way would be something like:

long time = date.getTime();
date.setTime((time / 1000) * 1000);

In other words, clear out the last three digits of the "millis since 1970 UTC".

I believe that will also clear the nanoseconds part if it's a java.sql.Timestamp.

Answer 2

Here is an idea:

public static void main(String[] args) {
       SimpleDateFormat df = new SimpleDateFormat("S");
       Date d = new Date();
       System.out.println(df.format(d));
       Calendar c = Calendar.getInstance();
       c.set(Calendar.MILLISECOND, 0);
       d.setTime(c.getTimeInMillis());
       System.out.println(df.format(d));

}

Answer 3

java.util.Calendar can help you.

    Calendar instance = Calendar.getInstance();
    instance.setTime(date);
    instance.clear(Calendar.SECOND);
    date = instance.getTime();