How to obtain the current time using the CURTIME() function?

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_TIME() - Synonym for CURTIME()

⇒ DATE() - Extracting Date

⇐ CURRENT_TIMESTAMP() - Synonym for NOW()

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References