TIMESTAMPDIFF(unit,begin,end);

TIMESTAMPDIFF函數返回begin-end的結果，其中begin和end是DATE或DATETIME表達式。

TIMESTAMPDIFF函數允許其參數具有混合類型，例如，begin是DATE值，end可以是DATETIME值。 如果使用DATE值，則TIMESTAMPDIFF函數將其視為時間部分為“00:00:00”的DATETIME值。

unit參數是確定(end-begin)的結果的單位，表示為整數。 以下是有效單位：

MICROSECOND 微秒 SECOND 秒 MINUTE 分鐘 HOUR 小時 DAY 天 WEEK 周 MONTH 月份 QUARTER 季度 YEAR 年份

示例：

select timestampdiff(year, "2019-08-13 19:15:16","2020-08-14 13:47:37") as year
      ,timestampdiff(QUARTER, "2019-08-13 19:15:16","2020-08-14 13:47:37") as QUARTER
      ,timestampdiff(MONTH, "2020-07-14 13:47:37","2020-08-14 13:47:37") as MONTH
	  ,timestampdiff(WEEK , "2020-08-07 13:47:37","2020-08-14 13:47:37") as WEEK 
	  ,timestampdiff(DAY, "2020-08-13 13:47:37","2020-08-14 13:47:37") as DAY
	  ,timestampdiff(HOUR, "2020-08-14 12:47:37","2020-08-14 13:47:37") as HOUR
	  ,timestampdiff(MINUTE , "2020-08-14 12:47:37","2020-08-14 13:47:37") as MINUTE 
	  ,timestampdiff(SECOND , "2020-08-14 13:46:37","2020-08-14 13:47:37") as SECOND 

總結

以上是生活随笔為你收集整理的MySQL timestampdiff()函数返回两个时间之间的差值「建议收藏」(关系型数据库管理系统)的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。