根据两个时间,计算两个时间差为几天几时几分几秒
SELECT concat( concat(timestampdiff(SECOND,IFNULL(‘2021/10/31 15:50:21’,NOW()),‘2021/12/15 14:55:23’) div 86400,‘天’), concat(timestampdiff(SECOND,IFNULL(‘2021/10/31 15:50:21’,NOW()),‘2021/12/15 14:55:23’) mod 86400 div 3600,‘时’), concat(timestampdiff(SECOND,IFNULL(‘2021/10/31 15:50:21’,NOW()),‘2021/12/15 14:55:23’) mod 3600 div 60,‘分’), concat(timestampdiff(SECOND,IFNULL(‘2021/10/31 15:50:21’,NOW()),‘2021/12/
共有 0 条评论