Mongodb: Perform a Date range query from the ObjectId in the mongo shell

by

You can do that in 2 steps:

 var objIdMin = ObjectId(Math.floor((new Date('1990/10/10'))/1000).toString(16) + "000
0000000000000")
 var objIdMax = ObjectId(Math.floor((new Date('2011/10/22'))/1000).toString(16) + "000
    0000000000000")
 db.myCollection.find({_id:{$gt: objIdMin, $lt: objIdMax}})

or in one step (what is less readable):

db.myCollection.find({_id:{$gt: ObjectId(Math.floor((new Date('1990/10/10'))/1000).toString(16) + "000
    0000000000000"), $lt: ObjectId(Math.floor((new Date('2011/10/10'))/1000).toString(16) + "000
    0000000000000")}})

More Related Contents:

  1. MongoDB $or query
  2. MEAN app vs. Mongo service local in Angular2
  3. Find objects between two dates MongoDB
  4. How to update the _id of one MongoDB Document?
  5. How to Model a “likes” voting system with MongoDB
  6. Overflow sort stage buffered data usage exceeds internal limit
  7. Slow pagination over tons of records in mongodb
  8. MongoDB – paging
  9. MongoDB query with an ‘or’ condition
  10. mongo.exe not installed in Version 6.0.0
  11. multiple instances of Mongo DB on same server
  12. How can I share MongoDB collections between Meteor apps?
  13. Where does mongodb stand in the CAP theorem?
  14. MongoDB: how to parse date in 3.6 mongoDb version?
  15. MongoDB – What about Decimal type of value?
  16. MongoDB – Querying between a time range of hours
  17. Delete a key from a MongoDB document using Mongoose
  18. Is shortening MongoDB property names worthwhile?
  19. Can mongodb be used as an embedded database?
  20. convert iso date to timestamp in mongo query
  21. Using $slice operator to get last element of array
  22. Save Subset of MongoDB Collection to Another Collection
  23. Meteor method vs. deny/allow rules
  24. Cannot authenticate into mongo, “auth fails”
  25. MongoDB via Mongoose JS – What is findByID?
  26. Find largest document size in MongoDB
  27. MongoDB to Use Sharding with $lookup Aggregation Operator
  28. Export mongodb aggregation framework result to a new collection
  29. MongoDB aggregate by field exists
  30. MongoDB {aggregation $match} vs {find} speed

Leave a Comment