MICROSECOND

Retrieve the microsecond component from a datetime value.

SELECT MICROSECOND(“2017-06-20 09:34:00.000023”);

Definition and Usage

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”);