db.Order.save({ “createTime” : NumberLong(1638497284724),amount:1});
db.Order.save({ “createTime” : NumberLong(1638397284724),amount:1});
mongo数据如下,需要按照月份统计金额
db.Order1.aggregate([
{ "$group": {
"_id": {
"$dateToString": {
"format": "%Y-%m",
"date": {
"$add": [
new Date(0),
"$createTime"
]
}
}
},
"total": { "$sum": "$amount"}
}
}
])
{ "_id" : "2021-12", "total" : 2 }`
如果需要按天统计,则需要 修改一下"format": “%Y-%m-%d”,