更簡(jiǎn)單的解決方案：

SELECT numtodsinterval(date1-date2,'day') time_difference from dates;

對(duì)于時(shí)間戳：

SELECT (extract(DAY FROM time2-time1)*24*60*60)+ 

(extract(HOUR FROM time2-time1)*60*60)+

(extract(MINUTE FROM time2-time1)*60)+

extract(SECOND FROM time2-time1)

into diff FROM dual;

RETURN diff;

分享編輯