更新时间:2022-12-09 22:33:16
我在sql上尝试了以下解决方案:
链接
I tried this solution on sql fieddle: link
表创建:
CREATE TABLE time_table (
id integer, time time
);
插入数据:
INSERT INTO time_table (id,time) VALUES
(1,'1:23:23'),
(2,'4:00:23'),
(3,'9:23:23')
查询数据:
SELECT
sum(s.time)
FROM
time_table s;