minutes between times.

[Apprentice101]

Can someone please help me with this procedure? It works sometimes and sometimes it does not. i think it may have something to do with decimals in the arythmetic operation.

any suggestions?

thanks!



PROCEDURE minute_interval IS
BEGIN
declare

total_minutes number;

begin

total_minutes:= surgery.time_out - :surgery.time_in)*1440;

:surgery.total_surg_time := total_minutes;


END;
END;

 

[Apprentice101]

found solution!, thanks

:surgery.total_surg_time := trunc(total_minutes);

 

[SantaMufasa]

Yes, Apprentice, dates include granularity down to seconds. If you subtract one date from another, the results include partial minutes (seconds), which appear as a value behind the decimal.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.