我在MongoDB中有一个集合和这样的文档-[{"campaignId":1,"operatorId":1,"txnType":"DR","amount":2,"balance":0,"txnTime":1428907779206,"txnSrc":"Dial_In","msisdn":"9789877667","circle":"Delhi","smsContent":"HelloMrArif"},{"campaignId":1,"operatorId":1,"txnType":"DR","circle":"Delhi","amount":2,"balance":0,"txnTime

我必须在mongodb聚合pipiline中将毫秒转换为日期格式-我的查询是-db.campaign_wallet.aggregate({"$match":{"campaignId":1,"txnTime":{"$gte":1429554600000,"$lte":1430159400000}}},{"$group":{"_id":{"msisdn":"$msisdn","txnTime":"$txnTime"},"count":{"$sum":1}}});在此查询中，如何将txnTime(以毫秒为单位)转换为管道中的日期？ 最佳答案

我必须在mongodb聚合pipiline中将毫秒转换为日期格式-我的查询是-db.campaign_wallet.aggregate({"$match":{"campaignId":1,"txnTime":{"$gte":1429554600000,"$lte":1430159400000}}},{"$group":{"_id":{"msisdn":"$msisdn","txnTime":"$txnTime"},"count":{"$sum":1}}});在此查询中，如何将txnTime(以毫秒为单位)转换为管道中的日期？ 最佳答案