MICROSECOND

声明

MICROSECOND(expr)

说明

返回时间或日期时间表达式 expr 的微秒数。

示例

SELECT MICROSECOND('12:00:00.999999');
+--------------------------------+
| MICROSECOND('12:00:00.999999') |
+--------------------------------+
|                         999999 |
+--------------------------------+
1 row in set (0.001 sec)

SELECT MICROSECOND('2021-07-15 18:20:17.000010');
+-------------------------------------------+
| MICROSECOND('2021-07-15 18:20:17.000010') |
+-------------------------------------------+
|                                        10 |
+-------------------------------------------+
1 row in set (0.000 sec)