Re: Time difference

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 28 Mar 2000 19:59:28 +0800
Message-ID: <38E09EA0.57E3@yahoo.com>

J Gao wrote:
>
> Hi,
>
> Is there any function in Oracle that can calculate the number of minutes
> between two Date columns? Thanks

if date1 - date2 = 3.123

the .123 = .123 of a day

thus .123 * 24 = the hours difference
  .123 * 24 * 60 = the mins difference

etc

HTH
--

---

Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse Received on Tue Mar 28 2000 - 05:59:28 CST