userimage

MongoDB/Mongoose querying at a specific date?

Is it possible to query for a specific date ?

I found in the mongo Cookbook that we can do it for a range Querying for a Date Range Like that :

db.posts.find({"created_on": {"$gte": start, "$lt": end}})

But is it possible for a specific date ? This doesn"t work :

db.posts.find({"created_on": new Date(2012, 7, 14) })

userimage

That should work if the dates you saved in the DB are without time (just day, month, year).
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)}})

Answer is