Collections:
CURTIME() - Current Time
How to obtain the current time using the CURTIME() function?
✍: FYIcenter.com
CURTIME(prec) is a MySQL built-in function that
returns the current time with a given precision of fractional seconds.
For example:
SELECT CURTIME(), CURTIME()+1; -- +-----------+-------------+ -- | CURTIME() | CURTIME()+1 | -- +-----------+-------------+ -- | 11:49:40 | 114941 | -- +-----------+-------------+ SELECT CURTIME(6), CURTIME(6)+1; -- +-----------------+---------------+ -- | CURTIME(6) | CURTIME(6)+1 | -- +-----------------+---------------+ -- | 11:51:06.460932 | 115107.460932 | -- +-----------------+---------------+
Reference information of the CURTIME() function:
CURTIME(prec): tm Returns the current time as a value in 'hh:mm:ss.SSSSSS' or hhmmss.SSSSSS format, depending on whether the function is used in string or numeric context. Arguments, return value and availability: prec: Optional. Default is 0. The precision of fractional seconds. tm: Return value. The current time as a string or number. Available since MySQL 4.
Related MySQL functions:
⇐ CURRENT_TIMESTAMP() - Synonym for NOW()
2023-11-17, 2192🔥, 0💬
Popular Posts:
Where to find reference information and tutorials on MySQL database functions? I want to know how to...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...