javascript - 如何构造日期范围查询？

Question

我的mongo文档如下

{{

"startTime" : "2012-12-06T18:30:00.000Z",
"endTime" : "2012-12-07T18:30:00.000Z",
"cost" : "40",
"_id" : ObjectId("50c31b65d2dfa2271b000001")
}
{

"startTime" : "2012-12-07T18:30:00.000Z",
"endTime" : "2012-12-08T18:30:00.000Z",
"cost" : "40",
"_id" : ObjectId("50c31b65d2dfa2271b000001")
}
{

"startTime" : "2012-12-05T18:30:00.000Z",
"endTime" : "2012-12-07T18:30:00.000Z",
"cost" : "40",
"_id" : ObjectId("50c31b65d2dfa2271b000001")
}
}

我尝试根据日期范围查询 mongo 文档，我的查询如下:

db.collection.find({"startTime":{"$gte":"2012-12-05T18:30:00.000Z"},"endTime":  {"$lt":"2012-12-12T18:30:00.000Z"}});

响应为空...

Answer 1

按如下方式更改您的查询，它将按预期返回结果。

db.collection.find({"startTime":{"$gte":ISODate("2012-12-05T18:30:00.000Z")},"endTime":  {"$lt":ISODate("2012-12-12T18:30:00.000Z")}});