Hi Gurus,
I am trying to calculate percentage completion for a process.
I have expected_end_time and start_time for that process.Is there any formula we can use to get percentage remaining based on these dates?
SELECT TO_DATE('11/23/2021 10:31:12 PM','MM/DD/YYYY HH:MI:SS AM') AS EXPECTED_END_TIME,
TO_DATE('11/23/2021 10:00:00 PM','MM/DD/YYYY HH:MI:SS AM') AS START_TIME,
(TO_DATE('11/23/2021 10:31:12 PM','MM/DD/YYYY HH:MI:SS AM')- TO_DATE('11/23/2021 10:00:00 PM','MM/DD/YYYY HH:MI:SS AM'))*24*60 diff_in_min
FROM DUAL;
Thanks