如何在MongoDB中根据天数开始和结束日期查找记录

hgb9j2n6  于 2022-09-18  发布在  Go
关注(0)|答案(0)|浏览(105)

如何使用开始、结束日期考虑天数从MongoDB返回多个对象?

用户输入-

start = "2022-09-08"
end   = "2022-09-17"

MongoDB对象

{
        "id": "63199ee82baa3643e58ed0f1",
        "start": "2022-09-08",
        "end": "2022-09-20",
        "startTime": "09:00",
        "endTime": "05:10",
        "timezone": "Europe/Rome",
        "days": [
            "Friday"
        ],
        "type": {
            "type": "remote",
            "label": "Video"
        },
        "interval": "15m",
        "store": "63199ee82baa3643e5887676"
    }

预期产出-返回2022-09-09和2022-09-16,因为这两个日期都在开始日期和结束日期之间今天也是星期五

[{
        "id": "63199ee82baa3643e58ed0f1",
        "start": "2022-09-09",
        "end": "2022-09-09",
        "startTime": "09:00",
        "endTime": "05:10",
        "timezone": "Europe/Rome",
        "days": [
            "Friday"
        ],
        "type": {
            "type": "remote",
            "label": "Video"
        },
        "interval": "15m",
        "store": "63199ee82baa3643e5887676"
    },
    {
        "id": "63199ee82baa3643e58ed0f1",
        "start": "2022-09-16",
        "end": "2022-09-16",
        "startTime": "09:00",
        "endTime": "05:10",
        "timezone": "Europe/Rome",
        "days": [
            "Friday"
        ],
        "type": {
            "type": "remote",
            "label": "Video"
        },
        "interval": "15m",
        "store": "63199ee82baa3643e5887676"
    }]

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题