SQL TIME_TO_SEC()函數
TIME_TO_SEC(time)
返回時間參數轉換成秒。
mysql> SELECT TIME_TO_SEC('22:23:00'); +---------------------------------------------------------+ | TIME_TO_SEC('22:23:00') | +---------------------------------------------------------+ | 80580 | +---------------------------------------------------------+ 1 row in set (0.00 sec)