StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18294479
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2013-08-18T00:07:07.110
FavoriteCount
0
LastActivityDate
2018-03-05T16:48:45.027
LastEditDate
2018-03-05T16:48:45.027
LastEditorUserId
4544363
OwnerUserId
634824
ParentId
18287493
PostTypeId
2
Score
8
ViewCount
0
LastEditorDisplayName
text
Body
What you're asking for is currently being discussed in <a href="https://jira.mongodb.org/browse/SERVER-6310" rel="nofollow noreferrer">MongoDB issue SERVER-6310</a>. I found this in a link from <a href="https://groups.google.com/d/msg/mongodb-user/lMwSiqEJjmw/T8sPqIyu1zoJ" rel="nofollow noreferrer">a discussion thread</a>. The problem is common for any grouping by date, including SQL databases and NoSQL databases. In fact, I recently addressed this head on in RavenDB. There is a good description of the problem and a RavenDB solution <a href="http://ravendb.net/kb/61/working-with-date-and-time-in-ravendb#time-zone-conversions" rel="nofollow noreferrer">here</a>. The MongoDB issues discusses a workaround, which is similar to what I described in comments above. You precalculate the local times you are interested in, and group by those instead. It will be difficult to cover every time zone in the world with either approach. You should decide on a small handful of target zones that make sense for your user base, such as the per-office approach I described in the RavenDB article. UPDATE: This issue was solved in MongoDB in July 2017 (version 3.5.11). The solution is described in the first link above, but in short they have introduced a new object format for dates in aggregation expressions: <code>{ date: <dateExpression>, timezone: <tzExpression> }</code> that allows you to specify a timezone to use when aggregating. See <a href="https://docs.mongodb.com/manual/reference/operator/aggregation/hour/" rel="nofollow noreferrer">here</a> for another example in the Mongo docs.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to deal with the timezone issue when storing dates in utc using mongod?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMatt Johnson
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow to deal with the timezone issue when storing dates in utc using mongod?
 singulars
 PostTypePostTypeId
 PTQuestion
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
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COThank you. Hope MongoDB provides such an option in future.
 singulars
 PostPostId
 PO
 UserUserId
 USHrishi

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.