create or replace function Add_Times(d1 in date,NewTime in date) return date is hh number; mm number; ss number; hours number; dResult date; begin -- 下面依次取出时、分、秒 select to_number(to_char(NewTime,''''HH24'''')) into hh from dual; select to_number(to_char(NewTime,''''MI'''')) into mm from dual; select to_number(to_char(NewTime,''''SS'''')) into ss from dual; -- 换算出NewTime中小时总和，在一天的百分几 hours := (hh + (mm / 60) + (ss / 3600))/ 24; -- 得出时间相加后的结果 select d1 + hours into dResult from dual; return(dResult); end Add_Times;
-- 测试用例 -- select Add_Times(sysdate,to_date(''''2004-12-06 03:23:00'''',''''YYYY-MM-DD HH24:MI:SS'''')) from dual
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
