'加时间
select
sysdate,
(sysdate+1) as add_a_day,--加天数
(sysdate+1/24) as add_an_hour,--,加小时
(sysdate+1/(24*60)) as add_a_minute,--加分
(sysdate+1/(24*60*60)) as add_a_second --加秒
from dual
'选时间差分钟
select Round(To_Number(To_Date(endtime, 'HH24MI') - To_Date(begintime, 'HH24MI')) * 24, 1 ) as ptime from tbl
评论