Collections:
MICROSECOND() - Microseconds of Time
How to extract the microseconds from a given time using the MICROSECOND() function?
✍: FYIcenter.com
MICROSECOND(time) is a MySQL built-in function that
returns the microsecond value from a given time.
For example:
SELECT MICROSECOND(NOW()), NOW(); -- +---------------------+----------------------------+ -- | MICROSECOND(NOW(6)) | NOW(6) | -- +---------------------+----------------------------+ -- | 107349 | 2023-11-14 23:16:40.107349 | -- +---------------------+----------------------------+
Reference information of the MICROSECOND() function:
MICROSECOND(time): int Returns the microseconds from the time or datetime expression time as a number in the range from 0 to 999999. Arguments, return value and availability: time: Required. The time to extract the microsecond from. int: Return value. The microsecond value. Available since MySQL 4.
Related MySQL functions:
⇐ MAKETIME() - Making Time from Components
2023-11-17, 1408🔥, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How Many Groups of Data Types in MySQL? MySQL support 3 groups of data types as listed below: String...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
What Happens to an Arithmetic Operation with Two Different Data Types in SQL Server Transact-SQL? Wh...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...