MySQL Function Reference

MICROSECOND

Returns the microseconds (0-999999) from a time or datetime value.

MySQL 8.1

MICROSECOND(expr)

expr

The time or datetime value.

Examples

MySQL 8.1

SELECT MICROSECOND(date)
FROM Payments;

MySQL 8.1

SELECT member_name,
	MICROSECOND(birthday)
FROM FamilyMembers;