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 -> Re: Need Script That Calc Hours Between 2 Dates

Re: Need Script That Calc Hours Between 2 Dates

From: Chris Nelson <ChrisNelson_at_eaton.com>
Date: Tue, 13 Apr 1999 18:43:51 -0400
Message-ID: <3713C8A7.939516FA@eaton.com>


This seems to work:

SELECT TO_NUMBER( later_date - earlier_date) * 24 FROM table
/

Dan Navarro wrote:

> Does anyone have a script that calculates the difference between
> 2 dates in hours?
>
> Thanks in advance to anyone who can help ...
Received on Tue Apr 13 1999 - 17:43:51 CDT

Original text of this message

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