If you take 2 dats away from each other you are left with the days between them

i.e.

Select sysdate - to_date('05-AUG-01') from dual

is equal to the number of days between the dates, which could be converted into a number of minutes if you wanted.

Specifically you want the time a procedure started and ended.

Store the time it started in one variable and the time it finished in another variable. The do the math you require.

Maybe if timing is set to on it will also tell you how long a procedure took to run.

[Edited by Zamial on 08-06-2001 at 06:51 AM]