db.tb_lora_train_task.aggregate([
{$match:{state:5,createTime: {
$gte: new Date(Date.UTC(2023, 9, 21, 0, 0, 0)),
$lte: new Date(Date.UTC(2023, 9, 21, 23, 59, 59))
}}},
{
$project:{
_id:1,
diff:{$subtract:["$taskEndTime", "$taskStartTime"]}
}
}
])
统计结果:
diff单位:毫秒
$match : 匹配条件
$subtract: 减法运算符
$add: 加法运算符
$multiply: 乘法运算符
$divide: 除法运算符