Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: hour difference between two dates calculation???
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