在给定集合的开始日期和结束日期之间进行猫鼬查询 [英] Mongoose query between Start Date and End Date of a given collection

问题描述

我有以下收藏:

db.sponsoreds.insert([
{
    _id: 1,
    bannerPath: "dms1.jpg",
    startDate: new Date("December 12, 2015 12:00:00"),
    endDate: new Date("November 13, 2016 00:00:00")
},
{
    _id: 2,
    bannerPath: "dms2.jpg",
    startDate: new Date("January 12, 2015 12:00:00"),
    endDate: new Date("January 13, 2016 00:00:00")
},
{
    _id: 3,
    bannerPath: "dms3.jpg",
    startDate: new Date("November 12, 2017 12:00:00"),
    endDate: new Date("November 13, 2018 00:00:00")
 },
 {
 _id: 4,
 bannerPath: "grs1.jpg",
 startDate: new Date("February 01, 2016 12:00:00"),
 endDate: new Date("February 28, 2016 00:00:00")
}
])

如何查询今天在开始日期和结束日期之间的文档?

How do i query for documents that today is between their start and end dates?

这与建议的已经提出的问题"不是重复的，因为:

我在问今天是否在文档中的两个日期之间，而不是文档中的日期是否在两个日期之间.

I'm asking about whether Today is between 2 dates in the document and not whether a date in the document is between 2 dates.

推荐答案

db.sponsoreds.find({$and:[{startDate:{$lte:new Date()}},{endDate:{$gte:new Date()}}]})

会返回

{
        "_id" : 1,
        "bannerPath" : "dms1.jpg",
        "startDate" : ISODate("2015-12-12T17:00:00Z"),
        "endDate" : ISODate("2016-11-13T05:00:00Z")
}

今天运行于2016-02-01T10:01:41.539Z

when run today at 2016-02-01T10:01:41.539Z

这篇关于在给定集合的开始日期和结束日期之间进行猫鼬查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！