ROUND( AVG( TIME_TO_SEC( TIMEDIFF( f.loan_time, c.credit_time ))), 0 )/60/60/24
求两时间字段值差然后求平均值,精确到天
最新推荐文章于 2024-04-26 13:29:49 发布
ROUND( AVG( TIME_TO_SEC( TIMEDIFF( f.loan_time, c.credit_time ))), 0 )/60/60/24