How to aggregate by year-month-day on a different timezone
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 … Read more