TIMESTAMPDIFF(interval,datetime1,datetime2)
文章目录TIMESTAMPDIFF(interval,datetime1,datetime2)参数interval参数datetime1,datetime2TIMESTAMPDIFF(interval,datetime1,datetime2)timestampdiff函数日期或日期时间表达式之间的整数差,后-前,即datetime2-datetime1参数interval比较的单位。可以为以下数值YEAR。年QUARTER。季度MONTH。月WEEK。星期DAY。天HOUR。小时
复制链接