How to compose a time from hour, minute and second components using the MAKETIME() function?

MAKETIME(hour, minute, second) is a MySQL built-in function that composes a time from hour, minute and second components. For example:

SELECT MAKETIME(12,15,30), MAKETIME(12,15,30.123456);
  -- +--------------------+---------------------------+
  -- | MAKETIME(12,15,30) | MAKETIME(12,15,30.123456) |
  -- +--------------------+---------------------------+
  -- | 12:15:30           | 12:15:30.123456           |
  -- +--------------------+---------------------------+

Reference information of the MAKETIME() function:

MAKETIME(hour, minute, second): tm
  Returns a time value calculated from the hour, minute, and second
  arguments. The second argument can have a fractional part.

Arguments, return value and availability:
  hour: Required. The hour component of time, 0 to 23.
  minute: Required. The hour component of time, 0 to 59.
  second: Required. The second component of time, 0 to 59, with fraction.
  tm: Return value. The calculated time.
  Available since MySQL 4.

⇒ MICROSECOND() - Microseconds of Time

⇐ MAKEDATE() - Making Date from Days

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References