Can I query MongoDB ObjectId by date?

by

Popping Timestamps into ObjectIds covers queries based on dates embedded in the ObjectId in great detail.

Briefly in JavaScript code:

/* This function returns an ObjectId embedded with a given datetime */
/* Accepts both Date object and string input */

function objectIdWithTimestamp(timestamp) {
    /* Convert string date to Date object (otherwise assume timestamp is a date) */
    if (typeof(timestamp) == 'string') {
        timestamp = new Date(timestamp);
    }

    /* Convert date object to hex seconds since Unix epoch */
    var hexSeconds = Math.floor(timestamp/1000).toString(16);

    /* Create an ObjectId with that hex timestamp */
    var constructedObjectId = ObjectId(hexSeconds + "0000000000000000");

    return constructedObjectId
}


/* Find all documents created after midnight on May 25th, 1980 */
db.mycollection.find({ _id: { $gt: objectIdWithTimestamp('1980/05/25') } });

More Related Contents:

  1. How to properly reuse connection to Mongodb across NodeJs application and modules
  2. Implementing pagination in mongodb
  3. How to sort array inside collection record in MongoDB?
  4. MongoDB dot (.) in key name
  5. How do I query referenced objects in MongoDB?
  6. How to search in array of object in mongodb
  7. Using Multiple Mongodb Databases with Meteor.js
  8. Mongoose find/update subdocument
  9. using a variable in mongodb update
  10. Mongoose, Select a specific field with find
  11. How to sort in mongoose?
  12. How does the messages-count example in Meteor docs work?
  13. Get the _id of inserted document in Mongo database in NodeJS
  14. Bulk upsert in MongoDB using mongoose
  15. Mongoose/MongoDB result fields appear undefined in Javascript
  16. Is there a way to ‘pretty’ print MongoDB shell output to a file?
  17. How to get the size of single document in Mongodb?
  18. When to close MongoDB database connection in Nodejs
  19. How to exclude some fields from the document
  20. Why is an _id with ObjectID added to when using MongoDB’s $push to add new object to an array?
  21. Mongoose add multiple object to array if not exist based
  22. How to set _id to db document in Mongoose?
  23. What is a TransientTransactionError in Mongoose (or MongoDB)?
  24. Mongoose.js: Find user by username LIKE value
  25. Mongoose Not Creating Indexes
  26. is there a mongoose connect error callback
  27. Node.js mongodb driver async/await queries
  28. node.js mongodb select document by _id node-mongodb-native
  29. Group by Date with Local Time Zone in MongoDB
  30. Mongoose find() not returning result

Leave a Comment