Date with set fields gives arbitrary values every time it's invoked

Question

I'm trying to work with dates in sqlite and I need a way of comparing them. My issue is that when I try to save a setup date into the database it gives me new values; They however don't differ much - just in milliseconds.

Here's the code:

Date today = new Date();
today.setHours(0);
today.setMinutes(0);
today.setSeconds(0);

How do I make it to give me constant values ?

P.S. I could've divided it by 1000 and save but I use greenDao framework, which encapsulates the insertion logic.

Thanks.

dvlpr · Answer 1 · 2012-10-29T08:29:35.363

1

Try:

Calendar now = Calendar.getInstance();
now.set(Calendar.HOUR, 0);
now.set(Calendar.MINUTE, 0);
now.set(Calendar.SECOND, 0);
now.set(Calendar.MILLISECOND, 0);

date = now.getTime();

new Date() allocates the current time returned by System.currentTimeMillis(). Which means you are not resetting milliseconds in your code.

edited Oct 29 '12 at 08:29

answered Oct 15 '12 at 14:44

dvlpr

139
8

I think midnight also would like to reset minutes and hours. Maybe you want to update the example. – Markus Junginger Oct 21 '12 at 09:07
I have made the change. Thnx. – dvlpr Oct 29 '12 at 08:31

score 0 · Answer 2 · edited May 23 '17 at 12:04

I think you might want to look at Java Date rounding

Basically the answers suggest using Apache commons-lang DataUtils. See http://commons.apache.org/lang/api-3.1/index.html and especially the truncate method:

public static Date truncate(Date date,int field)
Truncate this date, leaving the field specified as the most significant field.

For example, if you had the datetime of 28 Mar 2002 13:45:01.231, if 
you passed with HOUR, it would return 28 Mar 2002 13:00:00.000. If this was passed with MONTH, it would return 1 Mar 2002 0:00:00.000.

Date with set fields gives arbitrary values every time it's invoked

2 Answers2