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, 248🔥, 0💬
Popular Posts:
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...