MongoDB aggregate within daily grouping [duplicate]

by

In Mongo 2.8 RC2 there is a new data aggregation operator: $dateToString which can be used to group by a day and simply have a “YYYY-MM-DD” in the result:

Example from the documentation:

db.sales.aggregate(
  [
     {
         $project: {
                yearMonthDay: { $dateToString: { format: "%Y-%m-%d", date: "$date" } },
                time: { $dateToString: { format: "%H:%M:%S:%L", date: "$date" } }
         }
     }
  ]
)

will result in: 

{ "_id" : 1, "yearMonthDay" : "2014-01-01", "time" : "08:15:39:736" }

More Related Contents:

  1. Group result by 15 minutes time interval in MongoDb
  2. Does MongoDB’s $in clause guarantee order
  3. $lookup on ObjectId’s in an array
  4. Moongoose aggregate $match does not match id’s
  5. Find in Double Nested Array MongoDB
  6. Check if every element in array matches condition
  7. MongoDB nested lookup with 3 levels
  8. Get a count of total documents with MongoDB when using limit
  9. Include all existing fields and add new fields to document
  10. Matching ObjectId to String for $graphLookup
  11. mongodb count num of distinct values per field/key
  12. MongoDB aggregation comparison: group(), $group and MapReduce
  13. Mongodb aggregation lookup with conditions
  14. How to get back the Original document back after aggregation
  15. MongoDB group by array inner-elements
  16. Multiple Counts with single query in mongodb
  17. How to return array of string with mongodb aggregation
  18. How to return just the nested documents of an array from all documents
  19. MongoDB lookup when foreign field is an array of objects
  20. Search on multiple collections in MongoDB
  21. Mongodb aggregation $group, restrict length of array
  22. Get n-th element of an array in MongoDB
  23. Geospatial $near within current document field value
  24. How do I rename fields when performing search/projection in MongoDB?
  25. mongodb aggregation framework match by nested documents
  26. count array occurrences across all documents with mongo
  27. $project in $lookup mongodb
  28. Mongodb, aggregate query with $lookup
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. Return the last “true” value for each group

Leave a Comment