mongodb 罗盘查询，对象Id在日期范围内

使用MongoDB罗盘查询对象ID在日期范围内

javascript
db.articles.insertMany([
  {
    _id: ObjectId(),
    title: "文章1",
    content: "这是文章1的内容",
    createdAt: new Date("2022-01-01")
  },
  {
    _id: ObjectId(),
    title: "文章2",
    content: "这是文章2的内容",
    createdAt: new Date("2022-01-10")
  },
  {
    _id: ObjectId(),
    title: "文章3",
    content: "这是文章3的内容",
    createdAt: new Date("2022-01-20")
  }
]);

javascript
var startDate = new Date("2022-01-01");
var endDate = new Date("2022-01-15");
db.articles.find({
  _id: {
    $gte: ObjectId(Math.floor(startDate.getTime() / 1000).toString(16) + "0000000000000000"),
    $lte: ObjectId(Math.floor(endDate.getTime() / 1000).toString(16) + "ffffffffffffffff")
  }
});

javascript
var startDate = new Date("2022-01-01");
var endDate = new Date("2022-01-15");
var articles = db.articles.find({
  _id: {
    $gte: ObjectId(Math.floor(startDate.getTime() / 1000).toString(16) + "0000000000000000"),
    $lte: ObjectId(Math.floor(endDate.getTime() / 1000).toString(16) + "ffffffffffffffff")
  }
});
while (articles.hasNext()) {
  var article = articles.next();
  print("标题：" + article.title);
  print("内容：" + article.content);
  print("创建时间：" + article.createdAt);
  print("----------------------------");
}