mongo通过时间戳按月统计

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”,