timestamp diff (单元、begin、结束);
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年
示例:
selecttimestampdiff(year,' 2019-08-1319336015336016 ',' 2020-08-14 13:47:37 ' ) as year,timestamp diff ' timestampdiff,' 2020-07-14 13:47:37 ',' 2020-08-14 timestampdiff(week,' 2020-08-07 13:47:37 ) timestampdiff ) day '2020-08-141:47:37 ' ) as DAY,timestampdiff,' 2020-08-14 12:47:37 ', ' 2020-08-1413333337 (12:20-2020-08-14-123320 ) ) timestampdiff(minute,' 2020-08-14 123:4733337