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, 1592🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, Ora...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...