February 4th, 2004, 02:17 PM
subtracting time in oracle
I want to test how long something takes to load. In my table I have a start_time and an end_time in format
dd-mon-yyyy hh24:mi:ss. If I want to get the difference in minutes, how would I do that.
Ex. start_time = '02-Feb-2004 01:19:02'
end_time = '02-Feb-2004 01:19:48'
The result should be 46 seconds.
When I tried to subtract the time by minutes I got some strange results. Please help.
February 4th, 2004, 04:08 PM