Edited at

MySQLのtime型の合計

More than 1 year has passed since last update.


サンプルテーブル


  • テーブル定義

Column
Type

time_onsite
time


  • データ

time_onsite

00:00:01

00:01:00

01:00:00


time型を秒に変換

select

time_onsite,
time_to_sec(time_onsite) as sec
from
time_table
;

time_onsite
sec

00:00:01
1

00:01:00
60

01:00:00
3600


time型の合計

select

sum( time_to_sec(time_onsite)) as total_sec,
sec_to_time(sum( time_to_sec(time_onsite))) as total_time
from
time_table
;

total_sec
total_time

3661
01:01:01