在Oracle中，是否有一个函数可以计算两个日期之间的差? [英] In Oracle, is there a function that calculates the difference between two Dates?

问题描述

在Oracle中，是否有一个函数可以计算两个日期之间的差异?如果不是，是否可以显示以小时和分钟为单位的两个日期之间的时差?

In Oracle, is there a function that calculates the difference between two Dates? If not, is a way to display the difference between two dates in hours and minutes?

查询:

SELECT Round(max((EndDate - StartDate ) * 24), 2) as MaximumScheduleTime,
       Round(min((EndDate - StartDate) * 24), 2)  as MinimumScheduleTime,
       Round(avg((EndDate - StartDate) * 24), 2) as AveragegScheduleTime
FROM table1

推荐答案

您可以在Oracle中减去两个日期.结果是FLOAT，代表两个日期之间的天数.您可以对小数部分进行简单的算术运算，以计算小时，分钟和秒.

You can subtract two dates in Oracle. The result is a FLOAT which represents the number of days between the two dates. You can do simple arithmetic on the fractional part to calculate the hours, minutes and seconds.

这是一个例子:

SELECT TO_DATE('2000/01/02:12:00:00PM', 'yyyy/mm/dd:hh:mi:ssam')-TO_DATE('2000/01/01:12:00:00AM', 'yyyy/mm/dd:hh:mi:ssam') DAYS FROM DUAL

结果:1​​.5

这篇关于在Oracle中，是否有一个函数可以计算两个日期之间的差?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！