mysql计算时间差-本例为计算分钟差然后/60计算小时保留一位小数,由于直接得小时只会取整

-- ORDER_TIME datetime NOT NULL(字段类型)
SELECT
so.`ID`,so.`ORDER_TIME`,NOW(),CONCAT(ROUND(TIMESTAMPDIFF(MINUTE,so.`ORDER_TIME`,NOW())/60,1),'') AS hourLater
FROM se_seal_order so
WHERE so.id=#{orderId};
原文地址:https://www.cnblogs.com/sung1024/p/11171782.html