How to aggregate by year-month-day on a different timezone

by

I’m not an expert on CET and its relation to UTC, but the following code (for the shell) should do a proper conversion (adding an hour) to a MongoDB date type:

db.dates.aggregate(
  {$project: {"tDate":{$add: ["$tDate", 60*60*1000]}, "eventCount":1, "customer":1}}
)

If you run that project command before the rest of your pipeline, the results should be in CET.

More Related Contents:

  1. Get names of all keys in the collection
  2. How to filter array in subdocument with MongoDB [duplicate]
  3. MongoDB: Combine data from multiple collections into one..how?
  4. mongodb group values by multiple fields
  5. Find in Double Nested Array MongoDB
  6. Multiple join conditions using the $lookup operator
  7. Conditional $sum in MongoDB
  8. Aggregate $lookup Total size of documents in matching pipeline exceeds maximum document size
  9. Get a count of total documents with MongoDB when using limit
  10. exclude fields in $lookup aggregation
  11. Mongodb Explain for Aggregation framework
  12. MongoDB aggregation comparison: group(), $group and MapReduce
  13. How to sum every fields in a sub document of MongoDB?
  14. Add some kind of row number to a mongodb aggregate command / pipeline
  15. Exception: can’t convert from BSON type EOO to Date
  16. Multiple Counts with single query in mongodb
  17. MongoDB sort documents by array elements
  18. Mongodb Aggregation Framework: Does $group use index?
  19. How to return array of string with mongodb aggregation
  20. How to return just the nested documents of an array from all documents
  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. Mongodb aggregation pipeline how to limit a group push
  25. MongoDB : aggregation framework : $match between fields
  26. mongodb aggregation framework match by nested documents
  27. Find documents whose array field contains at least n elements of a given array
  28. Generating a Structure for Aggregation
  29. $project in $lookup mongodb
  30. Return actual type of a field in MongoDB

Leave a Comment