如何根据mongodb中的两个字符串fild“day”和“month”查找谁的生日-解网

问：

我在mongoDB中有这个数据模型：

{
    "_id" : "KPu78LNXYKfraRF94",
    ...
    "aboutPage" : {
        ...
        "birthDay" : NumberInt(27),
        "birthMonth" : NumberInt(5)
    }
}

我想找到明天过生日的所有用户。是否可以从“birthDay”和“birthMonth”生成DateTime字段并查找文档？年份根本不重要，我没有关于它的数据。谢谢:)

mongodb mongodb查询

db.collection.aggregate([
  {
    $set: {
      birthDate: {
        "$dateFromParts": {
          "year": {
            "$year": "$$NOW"
          },
          "month": "$aboutPage.birthMonth",
          "day": "$aboutPage.birthDay"
        }
      }
    }
  },
  {
    "$set": {
      "daysFromToday": {
        "$dateDiff": {
          startDate: "$birthDate",
          endDate: "$$NOW",
          unit: "day"
        }
      }
    }
  },
  {
    "$match": {
      daysFromToday: {
        $gte: -1,
        $lt: 3
      }
    }
  },
  {
    "$unset": [
      "daysFromToday",
      "birthDate"
    ]
  }
])

蒙戈游乐场

如何根据mongodb中的两个字符串fild“day”和“month”查找谁的生日

How to find who has birthday based on two string filds "day" and "month" in mongodb

评论

评论