SELECT MICROSECOND('1997-12-31 23:59:59.000010'); : MICROSECOND « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. MICROSECOND
mysql>
mysql> SELECT MICROSECOND('1997-12-31 23:59:59.000010');
+-------------------------------------------+
| MICROSECOND('1997-12-31 23:59:59.000010') |
+-------------------------------------------+
|                                        10 |
+-------------------------------------------+
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');