-
TIMESTAMPDIFF(unit, datetime_expr1, datetime_expr2)
指定计算的时间单位,比如说 YEAR, MONTH, DAY, 两个时间的差值。
mysql> SELECT TIMESTAMPDIFF(MONTH, '2021-06-30', '2021-01-05');
# return -5
SELECT TIMESTAMPDIFF(YEAR, '1995-02-19', '2021-06-22') AS age;
# return 26
TIMESTAMPDIFF(unit, datetime_expr1, datetime_expr2)
指定计算的时间单位,比如说 YEAR, MONTH, DAY, 两个时间的差值。
mysql> SELECT TIMESTAMPDIFF(MONTH, '2021-06-30', '2021-01-05');
# return -5
SELECT TIMESTAMPDIFF(YEAR, '1995-02-19', '2021-06-22') AS age;
# return 26