Loading lesson path
Concept visual
Start at both ends
Return the microsecond part of a datetime: SELECT MICROSECOND("2017-06-20 09:34:00.000023");
Formula
The MICROSECOND() function returns the microsecond part of a time/datetime (from 0 to999999).
datetime )
Required. The time or datetime to extract the microsecond from
From MySQL 4.0
Return the microsecond part of a time value: SELECT MICROSECOND("23:59:59.000045");
❮ MySQL Functions