MongoDB/Mongoose querying at a specific date?

by

That should work if the dates you saved in the DB are without time (just year, month, day).

Chances are that the dates you saved were new Date(), which includes the time components. To query those times you need to create a date range that includes all moments in a day.

db.posts.find({ //query today up to tonight
    created_on: {
        $gte: new Date(2012, 7, 14), 
        $lt: new Date(2012, 7, 15)
    }
})

More Related Contents:

  1. Push items into mongo array via mongoose
  2. Avoid “current URL string parser is deprecated” warning by setting useNewUrlParser to true
  3. Cannot overwrite model once compiled Mongoose
  4. add created_at and updated_at fields to mongoose schemas
  5. How to populate a sub-document in mongoose after creating it?
  6. mongoose custom validation using 2 fields
  7. How to protect the password field in Mongoose/MongoDB so it won’t return in a query when I populate collections?
  8. Mongoose update without callback
  9. How to fix ‘Error: querySrv EREFUSED’ when connecting to MongoDB Atlas?
  10. Model.find() returns empty in mongoose [duplicate]
  11. Mongoose – caused by :: 11000 E11000 duplicate key error index?
  12. $lookup multiple levels without $unwind?
  13. Mongoose, update values in array of objects
  14. Setting expiry time for a collection in mongodb using mongoose
  15. Mongoose/mongoDB query joins.. but I come from a sql background
  16. passport.js passport.initialize() middleware not in use
  17. Error: getaddrinfo ENOTFOUND in nodejs for get call
  18. How to set limit for array size in Mongoose schema
  19. Mongoose indexing in production code
  20. MongooseError – Operation `users.findOne()` buffering timed out after 10000ms
  21. MongoDB – get documents with max attribute per group in a collection
  22. Connecting Heroku App to Atlas MongoDB Cloud service
  23. how to use populate and aggregate in same statement?
  24. Automatically remove referencing objects on deletion in MongoDB
  25. Mongoose nested query on Model by field of its referenced model
  26. Node.js – Mongoose – Check if a collection exists
  27. Which SchemaType in Mongoose is Best for Timestamp?
  28. Mongoose: ObjectId Comparisons fail inconsistently
  29. Mongoose multiple connections
  30. set field as empty for mongo object using mongoose

Leave a Comment