It would be far better and easier if you could store your start/stop times as Oracle DATE's - in which case (stop_date - start_date)/24 is the result you want.
If you must store them as numbers, then you're stuck with doing the arithmetic the hard way.




Reply With Quote