Oracle:如何减去两个日期并获取结果的分钟数 [英] Oracle : how to subtract two dates and get minutes of the result

问题描述

我编写了此函数来获取日期中的分钟，但是我无法获取两个日期之间的分钟，如何获取?

I wrote this function to get minutes from a date, but I cannot get minutes between two dates, How to get that ?

FUNCTION get_minute(p_date DATE)
RETURN NUMBER
IS
BEGIN
    IF p_date IS NOT NULL THEN
        return  EXTRACT(MINUTE FROM TO_TIMESTAMP(to_char(p_date,'DD-MON-YYYY HH:MI:SS'),'DD-MON-YYYY HH24:MI:SS'));
    ELSE
        RETURN 0;
    END IF;
END get_minute;

推荐答案

在Oracle中减去两个日期时，将得到两个值之间的天数.因此，您只需要乘以分钟即可得到结果:

When you subtract two dates in Oracle, you get the number of days between the two values. So you just have to multiply to get the result in minutes instead:

SELECT (date2 - date1) * 24 * 60 AS minutesBetween
FROM ...

这篇关于Oracle:如何减去两个日期并获取结果的分钟数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！