搜搜考试网统计总时间问题,将时间换算成小时,有些地方看不懂,
来源：学生作业帮 编辑：搜搜考试网作业帮 分类：英语作业 时间：2024/06/09 10:01:42
统计总时间问题,将时间换算成小时,有些地方看不懂,
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和你一同笑过的人,你可能把他忘掉；但是和你一同哭过的人,你却永远不忘.有些事,你把它藏到心里,也许还更好,等时间长了,也就变成了故事.