TIME_FORMAT(SEC_TO_TIME(task_records.time_spent),'%Hh %im')
文档是您的朋友：
- http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html
根据评论：
DROp FUNCTION IF EXISTS GET_HOUR_MINUTES;CREATE FUNCTION GET_HOUR_MINUTES(seconds INT) RETURNS VARCHAr(16) BEGIN DECLARE result VARCHAr(16); IF seconds >= 3600 THEN SET result = TIME_FORMAT(SEC_TO_TIME(seconds),'%kh %lm'); ELSE SET result = TIME_FORMAT(SEC_TO_TIME(seconds),'%lm'); RETURN result; ENDDELIMETER ;
用法：
SELECT GET_HOUR_MINUTES(task_records.time_spent) FROM table
