我测试了这个：

SET @t = '19:00:00';

SELECT CONCAT_WS(', ', 
  CONCAT(NULLIF(TIME_FORMAT(@t, '%H'), '00'), ' hours'), 
  CONCAT(NULLIF(TIME_FORMAT(@t, '%i'), '00'), ' minutes'), 
  CONCAT(NULLIF(TIME_FORMAT(@t, '%s'), '00'), ' seconds')) AS time_expr;

输出：

+-----------+
| time_expr |
+-----------+
| 19 hours  |
+-----------+

当我安排时间做别的事情时：

SET @t = '19:00:05';

输出：

+----------------------+
| time_expr            |
+----------------------+
| 19 hours, 05 seconds |
+----------------------+

它甚至可以处理零小时：

SET @t = '00:43:00';

输出：

+------------+
| time_expr  |
+------------+
| 43 minutes |
+------------+

这是比尔答案的一个微小变化，它处理时间部分的复数：

SELECT CONCAT_WS(', ', 
                 CONCAT(hour(t), ' hour', (case hour(t) when 0 then NULL when 1 then '' else 's' end)), 
                 CONCAT(minute(t), ' minute', (case minute(t) when 0 then NULL when 1 then '' else 's' end)), 
                 CONCAT(second(t), ' second', (case second(t) when 0 then NULL when 1 then '' else 's' end))
                ) AS time_expr
from (SELECT CAST('19:01:01' as time) as t) x

你可以试试这个。

SELECT TIME_FORMAT( "19:00:00", 
    CONCAT(IF(HOUR("19:00:00") <> 0, "%H Hours", "") ,
    IF(MINUTE("19:00:00") <> 0, ", %i Minutes", "") ,
    IF(SECOND("19:00:00") <> 0, ", %s Seconds", ""))
);