calculate how many hours between call opening date and current date in pl/sql

Question

I need to make a query that brings the calls that are outside the 48 hrs SLA calculating the dates and times of the opening of the call and current date, someone can help me?

Answer 1

Friend, you can use DATEDIFF (https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/column_conversion_functions011.htm#GWURF780).

You can also use the suggested approaches in this Soen post: https://stackoverflow.com/questions/1096853/calculate-difference-between-2-date-times-in-oracle-sql .

After you find the difference between the dates just restrict those whose value is greater than 48 hours, in your case.

Answer 2

Subtracting two dates in Oracle results in difference in days (or fraction) to know in hours , multiply by 24.

Something like.

Select ...
From tabela
Where ...
And (datachamado - sysdate) * 24 >= 48
...