如何根据日期过滤/查找MongoDB中的记录 [英] How to filter/find records in MongoDB based on Date
问题描述
我在MongoDB数据库中有一个集合,该集合包含一些数据,并希望根据日期(忽略时间)过滤和查找数据.
I have a collection in MongoDB database that has some data and would like to filter and find data based on date (ignoring time).
样本数据
{
"_id" : ObjectId("563a38173c2ab9248c02d89e"),
"jobId" : "oAEKMcCIJRIAAAFQbrAR6NDd",
"jobName" : "CheckSessions",
"jobDesc" : "Checks and deletes expired session data",
"jobType" : "Job",
"startTime" : "2015-11-04 00:00:01",
"endTime" : "2015-11-04 00:00:01",
"domainName" : "root",
"recurrencePeriod" : "60",
"recurrencePeriodDesc" : "HOURS(1)"
}
{
"_id" : ObjectId("563a38173c2ab9248c02d89f"),
"jobId" : "C6wKMcCIJXoAAAFQm78R6NCm",
"jobName" : "CheckSessions",
"jobDesc" : "Checks and deletes expired session data",
"jobType" : "Job",
"startTime" : "2015-11-03 23:00:00",
"endTime" : "2015-11-03 23:00:01",
"domainName" : "root",
"recurrencePeriod" : "60",
"recurrencePeriodDesc" : "HOURS(1)"
}
我使用以下命令来获取大于特定日期的数据,但没有得到任何结果. startTime和endTime均为EST格式.不知道我在想什么.请指导.
I used the following command to fetch data greater than a specific date but it did not give me any results. Both startTime and endTime are in EST format. Not sure what am I missing. Please guide.
db.jobs.find({"startTime" : { $gt : new Date("2015-11-03")}});
推荐答案
答案:您可以简单地通过字符串比较进行查询.
Answer: You can query simply by string comparison.
首先,确保startTime列上的索引
First, ensure index on startTime column
db.test.ensureIndex({startTime:1})
以下命令使用_id:ObjectId("563a38173c2ab9248c02d89f")
db.test.find({
startTime: {
$gte: '2015-11-03 00:00:00',
$lt: '2015-11-04 00:00:00'
}
}).pretty()
通过在查询中运行explain(),我们可以看到索引实际上正在使用中:
By running explain() on our query, we can see the index is in fact in use:
db.test.find({startTime:{$gte:'2015-11-03 00:00:00', $lt:'2015-11-04 00:00:00'}}).explain()
{
"cursor" : "BtreeCursor startTime_1",
"isMultiKey" : false,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 1,
"nscannedAllPlans" : 1,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"startTime" : [
[
"2015-11-03 00:00:00",
"2015-11-04 00:00:00"
]
]
},
"server" : "Jaans-MBP.home:27017"
}
我的建议仍然是遵循最佳做法,并以正确的日期格式存储您的日期字段,例如
"startTime" : ISODate("2016-05-02T00:00:02Z")
您只需通过MongoDB shell
in MongoDB shell you'd simply pass
> db.test.insert({startTime:new Date()})
> db.test.find()
// results
{ "_id" : ObjectId("563a49d63b1f1b7df0ebc4f5"), "startTime" : ISODate("2015-11-04T18:09:26.613Z") }
这篇关于如何根据日期过滤/查找MongoDB中的记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!