欢迎各位兄弟 发布技术文章
这里的技术是共享的
返回秒参数,转化为小时,分钟和秒的值,格式如'HH:MM:SS'或HHMMSS,根据该函数是否用在字符串或数字语境中。
mysql> SELECT SEC_TO_TIME(2378); +---------------------------------------------------------+ | SEC_TO_TIME(2378) | +---------------------------------------------------------+ | 00:39:38 | +---------------------------------------------------------+ 1 row in set (0.00 sec)
+---------------------------------------------------------+ | SEC_TO_TIME(2378) | +---------------------------------------------------------+ | 00:39:38 | +---------------------------------------------------------+ 1 row in set (0.00 sec)