SQL MICROSECOND()函數
MICROSECOND(expr)
返回從時間或日期時間表達式expr的微秒,範圍從0到999999的數字。
mysql> SELECT MICROSECOND('12:00:00.123456'); +---------------------------------------------------------+ | MICROSECOND('12:00:00.123456') | +---------------------------------------------------------+ | 123456 | +---------------------------------------------------------+ 1 row in set (0.00 sec)