[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:
Duplicate
duplicates SERVER-6310 Timezone support in date operators at... Closed
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 SERVER-6310, since it looks like the same issue to me. Please watch that ticket and follow it for updates.

If you believe this is not a duplicate, please re-open this ticket with an explanation of why it is different. Thanks!

Generated at Thu Feb 08 04:08:39 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.