计算Oracle中两个时间戳之间的差异（以毫秒为单位）

Question

如何计算Oracle中两个时间戳之间的时间差（以毫秒为单位）？

Answer 1

更简单的解决方案：

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

对于时间戳：

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;

分享编辑