MySQL查询将timediff()转换为秒？
为此，您可以使用TIME_TO_SEC()函数。让我们首先创建一个表-
mysql> create table DemoTable -> ( -> SourceTime time, -> DestinationTime time -> );
使用插入命令在表中插入一些记录-
mysql> insert into DemoTable values('10:20:00','4:50:54');
mysql> insert into DemoTable values('12:05:10','7:45:12');使用select语句显示表中的所有记录-
mysql> select *from DemoTable;输出结果
这将产生以下输出-
+------------+-----------------+ | SourceTime | DestinationTime | +------------+-----------------+ | 10:20:00 | 04:50:54 | | 12:05:10 | 07:45:12 | +------------+-----------------+ 2 rows in set (0.00 sec)
以下是将时差转换为秒的查询-
mysql> SELECT ABS(TIME_TO_SEC(timediff(DestinationTime, SourceTime))) from DemoTable;输出结果
这将产生以下输出-
+---------------------------------------------------------+ | ABS(TIME_TO_SEC(timediff(DestinationTime, SourceTime))) | +---------------------------------------------------------+ | 19746 | | 15598 | +---------------------------------------------------------+ 2 rows in set (0.00 sec)