mysql 时间差
concat(
concat(( l.leave_time - l.enter_time ) DIV 86400, ‘天’ ),
concat(( l.leave_time - l.enter_time ) MOD 86400 DIV 3600, ‘时’ ),
concat( concat(( l.leave_time - l.enter_time ) MOD 86400 ) MOD 3600 DIV 60, ‘分’ ),
concat(( l.leave_time - l.enter_time ) MOD 60, ‘秒’ )) AS Parking_time,
2021-08-13
最新推荐文章于 2021-11-09 20:10:55 发布