如何在mongodb和nodejs中使用时间戳作为字段按天对记录进行分组

npm install mongodb

const MongoClient = require('mongodb').MongoClient;
const url = 'mongodb://localhost:27017/mydatabase'; // 替换为你的MongoDB连接URL
MongoClient.connect(url, function(err, client) {
  if (err) throw err;
  console.log('Connected to MongoDB');
  const db = client.db('mydatabase'); // 替换为你的数据库名称
  // 在这里执行分组操作
});

const collection = db.collection('mycollection'); // 替换为你的集合名称
collection.aggregate([
  {
    $group: {
      _id: {
        year: { $year: "$timestamp" },
        month: { $month: "$timestamp" },
        day: { $dayOfMonth: "$timestamp" }
      },
      count: { $sum: 1 },
      records: { $push: "$$ROOT" }
    }
  }
]).toArray(function(err, result) {
  if (err) throw err;
  console.log(result);
  client.close();
});