Important
Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.
MICROSECOND
On this page
The MICROSECOND() function 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: