Retrieve the microsecond component from a datetime value.
| SELECT MICROSECOND(“2017-06-20 09:34:00.000023”); |
The MICROSECOND() function retrieves the microsecond component of a time or datetime value, ranging from 0 to 999999.
| MICROSECOND(datetime) |
|
Parameter |
Description |
|
datetime |
Mandatory: The time or datetime from which to extract the microsecond. |
|
Works in: |
From MySQL version 4.0 |
Retrieve the microsecond component from a given time value.
| SELECT MICROSECOND(“23:59:59.000045”); |