By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE CSQAgentReport (Queuetime TEXT(8))
INSERT INTO CSQAgentReport (Queuetime) VALUES
('00:00:05'), ('00:00:05'), ('00:00:08'),
('00:00:03'), ('00:00:02'), ('00:01:45'),
('00:00:05'), ('00:00:03'), ('00:00:06'),
('00:00:24'), ('00:00:06'), ('00:00:46');
SELECT TIME(AVG(strftime('%s', Queuetime)), 'unixepoch') avg_time
FROM CSQAgentReport
avg_time |
---|
00:00:18 |