统计总时间问题,将时间换算成小时,有些地方看不懂,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(p
来源：学生作业帮助网 编辑：六六作业网 时间：2025/01/09 21:38:33
统计总时间问题,将时间换算成小时,有些地方看不懂,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(p
统计总时间问题,将时间换算成小时,有些地方看不懂,
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(p
参考答案\x09和你一同笑过的人,你可能把他忘掉；但是和你一同哭过的人,你却永远不忘.有些事,你把它藏到心里,也许还更好,等时间长了,也就变成了故事.
难为情，我只会小学水平的题目