java 时间戳 calendar,在Java中重置时间戳的时间部分

In Java, given a timestamp, how to reset the time part alone to 00:00:00 so that the timestamp represents the midnight of that particular day ?

In T-SQL, this query will do to achieve the same, but I don't know how to do this in Java.

SELECT CAST( FLOOR( CAST(GETDATE() AS FLOAT ) ) AS DATETIME) AS 'DateTimeAtMidnight';

解决方案

You can go Date->Calendar->set->Date:

Date date = new Date(); // timestamp now

Calendar cal = Calendar.getInstance(); // get calendar instance

cal.setTime(date); // set cal to date

cal.set(Calendar.HOUR_OF_DAY, 0); // set hour to midnight

cal.set(Calendar.MINUTE, 0); // set minute in hour

cal.set(Calendar.SECOND, 0); // set second in minute

cal.set(Calendar.MILLISECOND, 0); // set millis in second

Date zeroedDate = cal.getTime(); // actually computes the new Date

I love Java dates.

Note that if you're using actual java.sql.Timestamps, they have an extra nanos field. Calendar of course, knows nothing of nanos so will blindly ignore it and effectively drop it when creating the zeroedDate at the end, which you could then use to create a new Timetamp object.

I should also note that Calendar is not thread-safe, so don't go thinking you can make that a static single cal instance called from multiple threads to avoid creating new Calendar instances.