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, 1353🔥, 0💬
Popular Posts:
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema in Oracle? For a us...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...