大家好，又见面了，我是你们的朋友全栈君。
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
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/138911.html原文链接：https://javaforall.net
