首批通过分布式安全可靠测评,为关键业务系统打造
MICROSECOND
更新时间:2026-04-16 00:11:36
编辑
分享
声明
MICROSECOND(expr)
说明
返回时间或日期时间表达式 expr 的微秒数。
示例
obclient> SELECT MICROSECOND('12:00:00.999999');
+--------------------------------+
| MICROSECOND('12:00:00.999999') |
+--------------------------------+
| 999999 |
+--------------------------------+
1 row in set
obclient> SELECT MICROSECOND('2021-07-15 18:20:17.000010');
+-------------------------------------------+
| MICROSECOND('2021-07-15 18:20:17.000010') |
+-------------------------------------------+
| 10 |
+-------------------------------------------+
1 row in set