How to obtain the time from a datetime using the TIME() function?

TIME(dt) is a MySQL built-in function that returns the time from a datetime. For example:

SELECT TIME('2023-12-31 01:02:03');
  -- +-----------------------------+
  -- | TIME('2023-12-31 01:02:03') |
  -- +-----------------------------+
  -- | 01:02:03                    |
  -- +-----------------------------+

SELECT TIME(NOW()), TIME(NOW(6));
  -- +-------------+-----------------+
  -- | TIME(NOW()) | TIME(NOW(6))    |
  -- +-------------+-----------------+
  -- | 15:00:48    | 15:00:48.187593 |
  -- +-------------+-----------------+

Reference information of the TIME() function:

TIME(expr): tm
  Extracts the time part of the time or datetime expression expr and
  returns it as a string.

Arguments, return value and availability:
  expr: Required. The datetime to extract time from.
  tm: Return value. The extracted time.
  Available since MySQL 4.

Related MySQL functions:

• DATE() - Extracting Date

⇒ TIMEDIFF() - Difference of Two Timestamps

⇐ SYSDATE() - Current Timestamp

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References