StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
11534002
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-07-18T03:45:54.220
FavoriteCount
0
LastActivityDate
2012-07-18T03:53:49.783
LastEditDate
2012-07-18T03:53:49.783
LastEditorUserId
1380680
OwnerUserId
1380680
ParentId
11533839
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
You could follow <a href="http://en.wikipedia.org/wiki/ISO_8601#Time_intervals" rel="nofollow">ISO 8601</a>, a PDF of the spec can be found <a href="http://dotat.at/tmp/ISO_8601-2004_E.pdf" rel="nofollow">here</a>. See section <code>4.4.3 Duration</code> However, using the convention as lined out in this document looks fairly complicated to me, because according to this specification, you need to include context about when the time interval takes place: <blockquote> The duration of a calendar year, a calendar month, a calendar week or a calendar day depends on its position in the calendar. Therefore, the exact duration of a nominal duration can only be evaluated if the duration of the calendar years, calendar months, calendar weeks or calendar days used are known. </blockquote> If the actual moment at which the time span takes place is not relevant for your application, then maybe it would be good enough to forget about the year and month parts and just stick with the format <code>nnDTnnHnnMnnS</code>. That should not be too hard to achieve using the standard <code>TimeSpan</code> methods. Update: Reading a bit further, this standard does not seem to be applicable to your problem after all: <blockquote> Duration is used as a component in representations of time intervals and recurring time intervals, representation of duration as such is not facilitated by this International Standard. </blockquote> I will just leave the answer here to avoid anybody else walking into this dead end like I did, or if you think 'sort of following a standard' is good enough...
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POwhat is the standard way to display time span over 24 hours?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USReinier Torenbeek
UserOwnerUserId
1. USReinier Torenbeek
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. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.