Mongoose aggregate $match $get $lte date

snvhrwxg 于 11个月前发布在 Go

关注(0)|答案(1)|浏览(106)

如果请求带有startDate endDate查询，我试图匹配日期。但是我使用下面的方法返回空数据。

try {
    console.log(req.query.startDate);
    console.log(new Date(req.query.startDate));
    console.log(new Date(req.query.startDate).toISOString());

    let match = {};
    if (req.query.userId) {
        match.userId = req.query.userId;
    }

    if (req.query.startDate && req.query.endDate) {
        match.createdAt = {
            $gte: new Date(req.query.startDate),
            $lt: new Date(req.query.endDate)
        };
    }

    const docs = await Sale.aggregate([{
            $match: match
        }
    ]);
    return res.status(200).json({
        docs
    });
}

From console log:
2019-01-01
2019-01-01T00:00:00.000Z
2019-01-01T00:00:00.000Z

字符串

mongoose

来源：https://stackoverflow.com/questions/58588854/mongoose-aggregate-match-get-lte-date

1条答案

按热度按时间

qvtsj1bj1#

尝试将日期设置为ISO字符串

try {
console.log(req.query.startDate);
console.log(new Date(req.query.startDate));
console.log(new Date(req.query.startDate).toISOString());

let match = {};
if (req.query.userId) {
    match.userId = req.query.userId;
}

if (req.query.startDate && req.query.endDate) {
    match.createdAt = {
        $gte: req.query.startDate.toISOString(),
        $lt: req.query.endDate.toISOString()
    };
}

const docs = await Sale.aggregate([{
        $match: match
    }
]);
return res.status(200).json({
    docs
});

字符串
}

赞(0）回复(0）举报 11个月前

我来回答

Mongoose aggregate $match $get $lte date

1条答案

相关问题

热门标签

最新问答