Timezone support in date-time aggregation functions

XMLWordPrintableJSON

    • Type: New Feature
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: 3.3.10
    • Component/s: Aggregation Framework
    • None
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      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"]}}

            Assignee:
            Unassigned
            Reporter:
            Roman Kisilenko
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: