select round(avg(timestampdiff(minute,create_time,out_time ) /60),3) as time from exp_action_tb a inner join express_tb b on a.exp_number = b.exp_number
意思是半分钟不计入么?
timestampdiff(minute,create_time,out_time ) 好像只会返回整数?
select round(avg(timestampdiff(minute,create_time,out_time ) /60),3) as time from exp_action_tb a inner join express_tb b on a.exp_number = b.exp_number
意思是半分钟不计入么?
timestampdiff(minute,create_time,out_time ) 好像只会返回整数?