MICROSECOND
On this page
Extracts the microseconds (fractional seconds part) from the given datetime.
Syntax
MICROSECOND(dateobj)Arguments
-
dateobj: a valid date, datetime, time, or parsable datetime string.
Return Type
Integer
Example
SELECT MICROSECOND('2019-03-25 10:15:21.000423') AS MICROSECONDS;
+------------------------------+
| MICROSECONDS |
+------------------------------+
| 423 |
+------------------------------+
1 row in set (503 ms)Related Topics
Last modified: May 31, 2023