你可以使用$dateToString https://docs.mongodb.com/v3.2/reference/operator/aggregation/dateToString/运算符以以下格式投影时间字符串字段HH:MM
然后您可以在中进行直接字符串比较$match https://docs.mongodb.com/v3.2/reference/operator/aggregation/match/#pipe._S_match query:
var filter = {};
filter.strBillDate = {
"$gte": new Date(req.params.fromdate),
"$lt": new Date(req.params.todate)
};
return Sales
.aggregate([{
$match: filter
}, {
"$project": {
"strBillNumber": 1,
"strBillAmt": 1,
"store_id": 1,
"strBillDate": 1,
"time": { "$dateToString": { "format": "%H:%M", date: "$strBillDate" } }
}
}, {
"$match":
{ "time": { "$gte": "17:15", "$lte": "19:30" } }
}])
.exec(function(err, salesdata) {
if (!err) {
return res.send(salesdata);
}
});
更有效的方法将涉及使用单个管道$redact https://docs.mongodb.com/v3.2/reference/operator/aggregation/redact/运算符如下:
Sales.aggregate([
{
"$redact": {
"$cond": [
{
"$and": [
{ "$gte": [ "$strBillDate", new Date(req.params.fromdate) ] },
{ "$lt": [ "$strBillDate", new Date(req.params.todate) ] },
{
"$gte": [
{
"$dateToString": {
"format": "%H:%M",
"date": "$strBillDate"
}
},
"17:15"
]
},
{
"$lte": [
{
"$dateToString": {
"format": "%H:%M",
"date": "$strBillDate"
}
},
"19:30"
]
}
]
},
"$$KEEP",
"$$PRUNE"
]
}
}
]).exec(function(err, salesdata) {
if (!err) {
return res.send(salesdata);
}
});