StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
19981167
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-11-14T15:08:02.897
FavoriteCount
0
LastActivityDate
2013-11-14T15:08:02.897
LastEditDate
LastEditorUserId
0
OwnerUserId
1036017
ParentId
19962305
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
<p>One of my colleagues eventually came up with the right answer. The problem with incrementally adding a month to a Calendar is that you go from Jan 31 to Feb 28 to Mar 28, instead of Mar 31. This adds inaccuracy. The solution is to add 1 month, 2 months, 3 months and so on to the original start date. Then you go from Jan 31 to feb 28 to Mar 31. Anyway, here is his solution, slightly altered by me.</p> <pre><code>public class TimeSpan { public int months; public int days; public int hours; public int minutes; } class DateCalculator { public static TimeSpan difference(Date later, Date earlier) { TimeSpan v = new TimeSpan(); /* Add months until we go past the target, then go back one. */ while (calculateOffset(earlier, v).compareTo(later) <= 0) { v.months++; } v.months--; /* Add days until we go past the target, then go back one. */ while (calculateOffset(earlier, v).compareTo(later) <= 0) { v.days++; } v.days--; /* Add hours until we go past the target, then go back one. */ while (calculateOffset(earlier, v).compareTo(later) <= 0) { v.hours++; } v.hours--; while (calculateOffset(earlier, v).compareTo(later) <= 0) { v.minutes++; } v.minutes--; return v; } private static Date calculateOffset(Date start, TimeSpan offset) { Calendar c = new GregorianCalendar(); c.setTime(start); c.add(Calendar.MONTH, offset.months); c.add(Calendar.DAY_OF_YEAR, offset.days); c.add(Calendar.HOUR, offset.hours); c.add(Calendar.MINUTE, offset.minutes); return c.getTime(); } public static void main(String[] args) { try { SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm"); df.setTimeZone(TimeZone.getTimeZone("EST")); Date from = df.parse("2013-01-31 00:00"); Date to = df.parse("2014-01-31 10:20"); TimeSpan ts = difference(to, from); System.out.printf("Months:%02d Days:%02d Hrs:%02d Mins:%02d\n", ts.months, ts.days, ts.hours, ts.minutes); } catch (Exception e) { e.printStackTrace(); } } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to get number of months, weeks, days and hours from now to a future time?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USRajV
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.