Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL: getting time difference in hours between two date columns
Hi,
I want to get the time difference in minutes of two date columns. I tried it with:
SELECT ROUND((from_date - until_date)*24*60) FROM date_table;
It seems to work. Is there a special function like BETWEEN_DAYS for this purpose too?
-- Matthias Wirtz - Norfolk, USAReceived on Wed Apr 30 2003 - 14:33:43 CDT