MySQL DATEDIFF TIMEDIFF

最新推荐文章于 2024-05-10 09:16:57 发布

ninja

最新推荐文章于 2024-05-10 09:16:57 发布

阅读量1w

点赞数

分类专栏： MySql

MySql 专栏收录该内容

46 篇文章 0 订阅

订阅专栏

DATEDIFF 只计算到天的单位

TIMEDIFF 精确到毫秒单位

mysql> SELECT DATEDIFF (
    ->     '2000-01-01 00:00:00.000000',
    ->     '2000-01-02 05:06:07.000008') A;
+------+
| A    |
+------+
|   -1 |
+------+
1 row in set (0.00 sec)

mysql> SELECT
    ->   TIMEDIFF ('2000-01-01 00:00:00.000000',
    ->             '2000-01-02 05:06:07.000008') A;
+------------------+
| A                |
+------------------+
| -29:06:07.000008 |
+------------------+
1 row in set (0.00 sec)

如果要以秒为单位返回，使用 TIME_TO_SEC 函数：

mysql> SELECT
    ->   TIME_TO_SEC(
    ->     TIMEDIFF ('2000-01-01 00:00:00.000000',
    ->              '2000-01-02 05:06:07.000008')) A;
+---------+
| A       |
+---------+
| -104767 |
+---------+
1 row in set (0.03 sec)