MongoDB find comparison with CurrentDate

Question

I want to get the current daytime documents from the MongoDB collection. My docs look like this:

{ 
    "_id" : ObjectId("55743941789a9abe7f4af3fd"), 
    "msisdn" : "9xxxxxxxxxx", 
    "act_date" : ISODate("2014-11-24T00:00:00Z"), 
    "date" : ISODate("2015-06-07T00:00:00Z"), 
    "recharge" : { "recharge_amt" : 0, "rechargetype" : "WEB" },
    "voice" : { "local_og_mou" : 20, "local_other_mobile_og_mou" : 0, "nld_og_mou" : 0, "nld_other_mobile_og_mou" : 10 }, 
    "gprs" : { "total_access_count" : 1, "total_datavolume_mb" : 42 }, 
    "sms" : { "freesms" : 3, "local_sms_count" : 0, "nat_sms_count" : 0, "inter_sms_count" : 0 } 
}

Answer 1

According to your question, you want to receive documents of the current day from the mongodb collection . In the mongoDB shell, when you enter new Date()it, it gives you the current date with time, and this value always changes when you run the same new Date(), so your query probably looks like this:

db.collectionName.find({"start_date":new Date()}).pretty()

But I think that this query returns those documents that will be presented in your collection, but the same value of the current value Datemay not be presented in your documents. In this case, you should use the following

db.collectionName.find({"start_date":{"$lte":new Date()}}).pretty()

Or

db.collectionName.find({"start_date":{"$gte":new Date()}}).pretty()

year,month,day, aggregation $year, $month, $dayOfMonth $project, :

db.collectionName.aggregate({
  "$project": {
    "year": {
      "$year": "$date"
    },
    "month": {
      "$month": "$date"
    },
    "day": {
      "$dayOfMonth": "$date"
    }
  }
}, {
  "$match": {
    "year": new Date().getFullYear(),
    "month": new Date().getMonth() + 1, //because January starts with 0
    "day": new Date().getDate()
  }
})

, , year,month,day . $match

var currentDate = new Date()

 {
  "$match": {
    "year": currentDate.getFullYear(),
    "month": currentDate.getMonth() + 1, //because January starts with 0
    "day": currentDate.getDate()
  }
}

Answer 2

, .

db.collection.find({"start_date" : { $gte : new ISODate("2015-05-27T00:00:00Z") }});

: , .

,

db.collection.find({"start_date" : new ISODate("2015-05-27T00:00:00Z") });