MongoDB找到与CurrentDate的Query比较(MongoDB find Query comparision with CurrentDate)

MongoDB找到与CurrentDate的Query比较(MongoDB find Query comparision with CurrentDate)

我想从MongoDB集合中获取当天的文档。 我的文件看起来像这样：

{ "_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 } }

I want to fetch current day documents from a MongoDB collection. My documents 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 } }

最满意答案

根据您的问题， 您想从mongodb集合中获取当前日期文档 。 在mongoDB shell中，当你键入new Date()它会给你当前的日期和时间，当你运行相同的new Date()时，这个值总是变化的，所以你的查询可能是这样的：

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

但是，我认为此查询会返回将在您的集合中显示的那些文档，但您的文档中可能不会显示相同的当前Date值。所以这种情况下您应该使用以下

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

要么

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

在某些情况下如果你想找到与year,month,day完全匹配year,month,day那么你应该在$ project中使用$ year，$ month，$ dayOfMonth聚合，如下所示：

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() } }

As per your question you want to fetch current day documents from a mongodb collection. In mongoDB shell when you type new Date() it gives you current date with time and this value always vary when you run same new Date() so probably your query like this :

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

But, I think this query return the those documents which will presents in your collection but same current Date value may be not presents in your documents SO this case you should use following

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

Or

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

In some case If you want to find exact match with year,month,day then you should use aggregation with $year,$month,$dayOfMonth in $project like this :

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() } })

In above aggregation query will return those documents which match current date like year,month,day of current date. Also you replace $match as

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