Xref: alice comp.databases.oracle.misc:22516
Path: alice!news-feed.fnsi.net!newsfeed.wli.net!su-news-hub1.bbnplanet.com!su-news-feed1.bbnplanet.com!news.gtei.net!inet16.us.oracle.com!not-for-mail
From: "Christopher Beck" <clbeck@us.oracle.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: hour difference between two dates calculation???
Date: Wed, 11 Nov 1998 21:13:05 -0500
Organization: Oracle Corp.
Lines: 43
Message-ID: <72dh1b$g44$1@inet16.us.oracle.com>
References: <72d5qi$hnr$1@nnrp1.dejanews.com>
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4


selkadiki@my-dejanews.com wrote in message
<72d5qi$hnr$1@nnrp1.dejanews.com>...
>How can I calculate the difference in hours between two Oracle date
datatypes?
>I know in Sybase you can use the datediff function, is there something
>equivalent or does someone have a procedure to do this.


Sure.  If you subtract the two dates, you will get a number which will
represent the
number of days between them.  If you multiple that value by 24 you will get
the result
in hours.

eg

SQL> select ( (sysdate+1/24) - sysdate ) * 24 from dual;

((SYSDATE+1/24)-SYSDATE)*24
---------------------------
                          1


Hope this helps.

chris.

--

Christopher Beck
clbeck@us.oracle.com


>
>Good day!
>
>Sal Elkadiki
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own