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: hour difference between two dates calculation???

Re: hour difference between two dates calculation???

From: <stevec_at_zimmer.csufresno.edu>
Date: Thu, 12 Nov 1998 18:22:29 GMT
Message-ID: <72f915$a0c$1@nnrp1.dejanews.com>


In article <72d5qi$hnr$1_at_nnrp1.dejanews.com>,   selkadiki_at_my-dejanews.com wrote:
> 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.
>
> Good day!
>
> Sal Elkadiki

To see an example of subtracting two dates, you can look at the "Programming Tips" link on my website: http://members.aol.com/stevec5088

It displays the hours, minutes and seconds between two dates.

Steve Cosner

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Nov 12 1998 - 12:22:29 CST

Original text of this message

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