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

Collection find on ISODate

    XMLWordPrintableJSON

Details

    • Icon: Question Question
    • Resolution: Done
    • Icon: Minor - P4 Minor - P4
    • None
    • None
    • Querying
    • None

    Description

      Does the ordering of "date", "timezone", "timezone_type" matters for an ISODate attribute matters on insert/find of a document?

       

      We noticed that a find operation on an ISODate object that was inserted with timezone_type, date, timezone didn`t match any documents and when we switched the attribute order in the object to date, timezone_type, timezone it worked as expected. 

       

      Sample query used: db.test_col.find({to: { $gt:

      { date: "2019-04-17 13:45:07.000000", timezone_type: 1, timezone: "+00:00" }

      } });

      Attachments

        Activity

          People

            eric.sedor@mongodb.com Eric Sedor
            alex_aslan Alex Aslan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: