CONCAT(
FLOOR(
TIMESTAMPDIFF(
SECOND,
beginTime,
endTime
) / 86400
),
'天',
TIMESTAMPDIFF(
HOUR,
beginTime,
endTime
) % 24,
'时',
TIMESTAMPDIFF(
MINUTE,
beginTime,
endTime
) % 60,
'分'
) AS useTime
MySQL查询两个日期之间的时间差(多少天多少时多少分)
最新推荐文章于 2024-05-10 09:16:57 发布