mongodb操作记录

分时间段聚合统计总数

db.callRecordMongo.aggregate([
{$group:{
        _id:{ $dateToString: { format: "%Y-%m-%d %H:%M:%S", date: "$callDate" ,timezone: "Asia/Shanghai"} },
				
         count:{$sum:1}
         
        }
},
{ $project: { 
     日期: { $toUpper: "$_id" },
     吞吐量: "$count",
     _id: 0 } 
},
{ $sort: { "_id": -1 } 
}
]
)

删除时间段大于时间戳的记录

db.callRecordMongo.deleteMany({"callTime": {$gte:1642557979541}})