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, 987🔥, 0💬
Popular Posts:
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...