Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

MICROSECOND(expr) returns the microseconds as a number in the range from 0 to 999999

mysql> mysql> SELECT MICROSECOND('12:00:00.123456'); +--------------------------------+ | MICROSECOND('12:00:00.123456') | +--------------------------------+ |                         123456 | +--------------------------------+ 1 row in set (0.00 sec) mysql>