MICROSECOND()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
Returns the microseconds from the time or datetime expression expr as a number in the range from 0 to 999999.
EXAMPLES
SELECT MICROSECOND('10:02:01.123');
+-----------------------------+
| MICROSECOND('10:02:01.123') |
+-----------------------------+
| 123000 |
+-----------------------------+
SELECT MICROSECOND('2019-01-30 10:02:01.1');
+--------------------------------------+
| MICROSECOND('2019-01-30 10:02:01.1') |
+--------------------------------------+
| 100000 |
+--------------------------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.