作业帮统计总时间问题,将时间换算成小时,有些地方看不懂,能解释分段解释下函数吗?
来源：学生作业帮 编辑：作业帮 分类：综合作业 时间：2024/05/29 05:46:01
统计总时间问题,将时间换算成小时,有些地方看不懂,能解释分段解释下函数吗?
select comcode,count(*) case_qty,
sum(substr(to_date(to_char(p1.payment_date, '%Y-%m-%d')|| ' 00:00:01', '%Y-%m-%d %H:%M:%S') - p1.reportTime, 1, 9) * 24 * 3600 +
substr(to_date(to_char(p1.payment_date, '%Y-%m-%d')|| ' 00:00:01', '%Y-%m-%d %H:%M:%S')- p1.reportTime, 11, 2) * 3600 +
substr(to_date(to_char(p1.payment_date, '%Y-%m-%d')|| ' 00:00:01', '%Y-%m-%d %H:%M:%S') - p1.reportTime, 14, 2) * 60 +
substr(to_date(to_char(p1.payment_date, '%Y-%m-%d')|| ' 00:00:01', '%Y-%m-%d %H:%M:%S') - p1.reportTime, 17, 2)) as compensate_secord
from temp_car_claim_pay p1
group by p1.comcode
select comcode,count(*) case_qty,
sum(substr(to_date(to_char(p1.payment_date, '%Y-%m-%d')|| ' 00:00:01', '%Y-%m-%d %H:%M:%S') - p1.reportTime, 1, 9) * 24 * 3600 +
substr(to_date(to_char(p1.payment_date, '%Y-%m-%d')|| ' 00:00:01', '%Y-%m-%d %H:%M:%S')- p1.reportTime, 11, 2) * 3600 +
substr(to_date(to_char(p1.payment_date, '%Y-%m-%d')|| ' 00:00:01', '%Y-%m-%d %H:%M:%S') - p1.reportTime, 14, 2) * 60 +
substr(to_date(to_char(p1.payment_date, '%Y-%m-%d')|| ' 00:00:01', '%Y-%m-%d %H:%M:%S') - p1.reportTime, 17, 2)) as compensate_secord
from temp_car_claim_pay p1
group by p1.comcode
参考答案\x09上天安排某人进入你的生活是有原因的,让他们从你的生活中消失肯定有一个更好的理由.