mysql - SQL 求和列值

Question

我有一个这样的表:

ID    Departure              Duration(in min)         
==============================================
1     2017-12-31 11:30:45     120
2     2017-06-16 22:31:46     240

我想将最后两列求和为:

ID    Departure              Duration(in min)   Arrival       
============================================================
1     2017-12-31 11:30:45     120        2017-12-31 13:30:45  
2     2017-06-16 22:31:46     240        2017-06-17 02:31:46

我该怎么做？

出发时间为时间戳

和持续时间 INT

Answer 1

您需要使用 ADDTIME 和 SEC_TO_TIME 函数来完成您的工作

SELECT ADDTIME(Departure,SEC_TO_TIME(Duration*60)) as Arrival

了解更多 http://www.w3resource.com/mysql/date-and-time-functions/mysql-addtime-function.php

和 http://www.w3resource.com/mysql/date-and-time-functions/mysql-sec_to_time-function.php