您的位置首页百科知识 timestamp计算 Simone 发布于 2025-04-05 01:31:39 574 阅读 timestamp计算的有关信息介绍如下:使用mysql自带的TIMESTAMPDIFF函数,语法为:TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2),其中unit有FRAC_SECOND , SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR。unit为SECOND就是精确到秒:TIMESTAMPDIFF(SECOND,时间列1,时间列2)