Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL: getting time difference in hours between two date columns

SQL: getting time difference in hours between two date columns

From: Matthias Wirtz <Matthias.Wirtz_at_epost.de>
Date: Wed, 30 Apr 2003 15:33:43 -0400
Message-ID: <b8p87m$c1ps6$1@ID-151394.news.dfncis.de>


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, USA
Received on Wed Apr 30 2003 - 14:33:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US