Collection find on ISODate

XMLWordPrintableJSON

    • Type: Question
    • Resolution: Done
    • Priority: Minor - P4
    • None
    • Affects Version/s: None
    • Component/s: Querying
    • None
    • None
    • None
    • None
    • None
    • None
    • None
    • None

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

      } });

            Assignee:
            Eric Sedor
            Reporter:
            Alex Aslan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: