MongoDB根据时间aggregate示例
//先存为日期//1
db.tmp_result.find({"value.Status":3},{"value.TranslateFields":1,"value.LastUpdate":1}).forEach(
function(item){
db.new_result.save({"LastUpdate":item.value.LastUpdate.getFullYear()+"-"+
(item.value.LastUpdate.getMonth()+1)+"-"+
item.value.LastUpdate.getDate(),
"TranslateFields":item.value.TranslateFields});
}
)
//2
db.new_result.aggregate(
{
$group : {
_id:"$LastUpdate",
totalTime: { $sum: "$TranslateFields" }
}
}
,{"$sort":{"_id":1}}
)
页:
[1]