[SERVER-25243] Timezone support in date-time aggregation functions Created: 23/Jul/16 Updated: 25/Jul/16 Resolved: 25/Jul/16 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Aggregation Framework |
| Affects Version/s: | 3.3.10 |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Major - P3 |
| Reporter: | Roman Kisilenko | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Participants: | |||||||||
| Description |
|
I have an app which needs to query DB for aggregate reports based on timezone. Currently we have to store dates in multiple timezones in order to make it possible to aggregate the data in the timezone expected. It would be great if date-time functions can calculate values based on timezone requested, like this: { $year: ["$date", "Europe/Moscow"]}or {$year: {$tz: ["$date", "Europe/Moscow"]}} |
| Comments |
| Comment by Charlie Swanson [ 25/Jul/16 ] |
|
Hi roman.kisilenko, I'm closing this ticket as a duplicate of If you believe this is not a duplicate, please re-open this ticket with an explanation of why it is different. Thanks! |