Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-25243

Timezone support in date-time aggregation functions

    XMLWordPrintable

    Details

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

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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              roman.kisilenko Roman Kisilenko
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: