计算oracle数据库字符串时间秒差值
发布时间：2020-12-12 16:28:33 所属栏目：百科 来源：网络整理
导读：1 原始数据 select t.record_date as rq, t.cal_current_status as curZT, round(to_number(to_date(to_char(t.cal_current_end_time, 'yyyy/mm/dd hh24:mi:ss'), 'yyyy/mm/dd hh24:mi:ss') - to_date(to_char(t.cal_current_begin_time, 'yyyy/mm/dd hh24:m
|
1 原始数据
select t.record_date as rq, t.cal_current_status as curZT,round(to_number(to_date(to_char(t.cal_current_end_time, 'yyyy/mm/dd hh24:mi:ss'), 'yyyy/mm/dd hh24:mi:ss') - to_date(to_char(t.cal_current_begin_time, 'yyyy/mm/dd hh24:mi:ss')) * 24 * 60, 2) as curTime, t.cal_series_status as serzt, round(to_number(to_date(to_char(t.cal_series_end_time, 'yyyy/mm/dd hh24:mi:ss') - to_date(to_char(t.cal_series_begin_time, 2) as serTime from tb_lh_ug_import_status t order by record_Date 2 格式化后数据 3 *24代表求小时差，*24*60代表求分钟差，*24*60*60代表求秒差 select to_number(to_Date('2017/8/4 0:04:14','yyyy/mm/dd hh24:mi:ss')-to_Date('2017/8/4 0:03:17','yyyy/mm/dd hh24:mi:ss'))*24*60*60 from dual; （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |