MICROSECOND(expr) returns the microseconds as a number in the range from 0 to 999999. : MICROSECOND « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. MICROSECOND
mysql>
mysql> SELECT MICROSECOND('12:00:00.123456');
+--------------------------------+
| MICROSECOND('12:00:00.123456') |
+--------------------------------+
|                         123456 |
+--------------------------------+
1 row in set (0.00 sec)

mysql>








14.28.MICROSECOND
14.28.1.MICROSECOND(expr) returns the microseconds as a number in the range from 0 to 999999.
14.28.2.SELECT MICROSECOND('1997-12-31 23:59:59.000010');