Aggregate in Mongo Using Only Date Part of a DateTime Property
Aggregate in Mongo Using Only Date Part of a DateTime Property
Join the DZone community and get the full member experience.
Join For FreeVerify, standardize, and correct the Big 4 + more– name, email, phone and global addresses – try our Data Quality APIs now at Melissa Developer Portal!
If you need to do an aggregation in MongoDB on a DateTime property and you want to aggregate only by Date part, you can use a simple trick and use a filter to compose the date part before the grouping. Here is the code:
db.mycollection.aggregate(
{
"$project" :
{
_id : 0,
"datePartDay" : {"$concat" : [
{"$substr" : [{"$dayOfMonth" : "$LastUpdate"}, 0, 2]}, "-",
{"$substr" : [{"$month" : "$LastUpdate"}, 0, 2]}, "-",
{"$substr" : [{"$year" : "$LastUpdate"}, 0, 4]}
] }
}
},
{ "$group" :
{ "_id" : "$datePartDay", "Count" : { "$sum" : 1 } }
}
)
Thanks to the power of aggregation framework, we can construct a pipeline where the first stage create a document with a new property that is composed only by the day-month-year. That new document can have id equal to zero if we only need a count based on that date field, or you can assign original id of the document or whatever else. The subsequent stage of the pipeline is a simple count where the id is the new field that contains only date part of the original DateTime property.
Developers! Quickly and easily gain access to the tools and information you need! Explore, test and combine our data quality APIs at Melissa Developer Portal – home to tools that save time and boost revenue. Our APIs verify, standardize, and correct the Big 4 + more – name, email, phone and global addresses – to ensure accurate delivery, prevent blacklisting and identify risks in real-time.
Like This Article? Read More From DZone
Published at DZone with permission of Ricci Gian Maria , DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}