Syntax
MICROSECOND(expr)
Purpose
You can call this function to return the number of microseconds from the time or datetime expression expr.
Examples
obclient> SELECT MICROSECOND('12:00:00.999999');
+--------------------------------+
MICROSECOND('12:00:00.999999')
+--------------------------------+
999999
+--------------------------------+
1 row in set (0.00 sec)
obclient> SELECT MICROSECOND('2021-07-15 18:20:17.000010');
+-------------------------------------------+
MICROSECOND('2021-07-15 18:20:17.000010')
+-------------------------------------------+
10
+-------------------------------------------+
1 row in set (0.00 sec)