postgresql - 在postgresql中将间隔转换为数字

Question

我创建了一个查询，它总结了各个日期时间的间隔，

select sum(ts_polling) / count(ts_polling) as Average_Queue_Wait_Time ,  cast(time_start AS Date)
  from callcent_queuecalls group by cast(time_start AS date) order by time_start DESC;

有没有办法将 Average_Queue_Wait_Time 从区间数据类型转换为数字？

Answer 1

您可以像这样获取间隔中的秒数:

SELECT EXTRACT(epoch FROM INTERVAL '1 day 30 minutes 1.234 seconds');

┌───────────┐
│ date_part │
├───────────┤
│ 88201.234 │
└───────────┘
(1 row)