mysql> SELECT SEC_TO_TIME (3600);+--------------------+| SEC_TO_TIME (3600) |+--------------------+| 01:00:00 |+--------------------+1 row in set (0.00 sec)mysql> SELECT TIME_TO_SEC(‘00:01:00‘) A;+----+| A |+----+| 60 |+----+1 row in set (0.00 sec)原文：http://www.cnblogs.com/hailexuexi/p/4482176.html