Android difference between two dates in seconds

android date seconds
Alin picture Alin · Oct 18, 2010 · Viewed 49.4k times · Source

I've tried different methods around the web but couldn't make it work. 

Cursor cursor = sqlite.myDataBase.rawQuery("SELECT StartDate, EndDate FROM Tracks Where Id="+'"'+trackId+'"',null);

SimpleDateFormat outputFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date startDate = outputFormat.parse(cursor.getString(cursor.getColumnIndex("StartDate")));
Date endDate = outputFormat.parse(cursor.getString(cursor.getColumnIndex("EndDate")));

In this way I get both dates in good format. Now I want to find the difference between EndDate and Startdate in seconds.

Any advice? Thank you.

Answer

Cheryl Simon picture Cheryl Simon · Oct 18, 2010

You can turn a date object into a long (milliseconds since Jan 1, 1970), and then use TimeUnit to get the number of seconds:

long diffInMs = endDate.getTime() - startDate.getTime();

long diffInSec = TimeUnit.MILLISECONDS.toSeconds(diffInMs);

Edit: -Corrected the name of the variable diffInMs which was written diffInM(i)s in the second line.

Related questions

How to get current time and date in Android

How can I get the current time and date in an Android app?

Read More
How to format date and time in Android?

How to format correctly according to the device configuration date and time when having a year, month, day, hour and minute?

Read More
How can I get current date in Android?

I wrote the following code Date d = new Date(); CharSequence s = DateFormat.format("MMMM d, yyyy ", d.getTime()); But is asking me parameter, I want current date in string format, like 28-Dec-2011 so that I can set over TextView, explain …

Read More