Oracle how to subtract two dates and get minutes of the result

Question

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

User · Answer

For those who want to substrat two timestamps (instead of dates), there is a similar solution:

SELECT ( CAST( date2 AS DATE ) - CAST( date1 AS DATE ) ) * 1440 AS minutesInBetween
FROM ...

or

SELECT ( CAST( date2 AS DATE ) - CAST( date1 AS DATE ) ) * 86400 AS secondsInBetween
FROM ...

User · Answer

I think you can adapt the function to substract the two timestamps   return  EXTRACT MINUTE FROM    TO TIMESTAMP to char p date1  DD-MON-YYYY HH MI SS    DD-MON-YYYY HH24 MI SS   -   TO TIMESTAMP to char p date2  DD-MON-YYYY HH MI SS    DD-MON-YYYY HH24 MI SS        I think you could simplify it by just using CAST p date as TIMESTAMP    return  EXTRACT MINUTE FROM cast p date1 as TIMESTAMP  - cast p date2 as TIMESTAMP      Remember dates and timestamps are big ugly numbers inside Oracle  not what we see in the screen  we don t need to tell him how to read them  Also remember timestamps can have a timezone defined  not in this case

User · Answer

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

User · Answer

I can handle this way   select to number to char sysdate  MI    - to number to char  YOUR DATA VALUE   MI    max exp time   from       Or  if you want to the hour just change the MI   select to number to char sysdate  HH24    - to number to char  YOUR DATA VALUE   HH24    max exp time   from       the others don t work for me   Good luck

[oracle] Oracle : how to subtract two dates and get minutes of the result

Examples related to oracle

Examples related to date

Examples related to plsql