version 11
MILLISECOND (arithmetic_expression)
Description
The MILLISECOND function returns the millisecond part of the time passed in arithmetic_expression.
Example
Supposing that we have the INVOICES table with a Delivery_Time field. To display the milliseconds of the delivery time:
SELECT MILLISECOND(Delivery_Time) FROM INVOICES;See Also