I need to subtract two datetime fields in Oracle to get the difference in minutes.
begin_lab_time = 2011.12.12 08:10:00
end_lab_time = 2011.12.12 08:31:00
expected result from subtracting these two fields: 21 minutes
How would I go about getting the expected result in Oracle?
I tried this but I get 20 minutes as the result and not 21 minutes. I need to get 21 minutes as the result: