返回參數(shù)秒值,轉(zhuǎn)化為小時,分鐘和秒,如“HH:MM:SS'值或HHMMSS格式,根據(jù)函數(shù)是否用在字符串或數(shù)字語境中。
mysql> SELECT SEC_TO_TIME(2378); +---------------------------------------------------------+ | SEC_TO_TIME(2378) | +---------------------------------------------------------+ | 00:39:38 | +---------------------------------------------------------+ 1 row in set (0.00 sec)