Re: Date arithmetic with oracle
From: Pauli Salmu <pauli.salmu_at_pp.kolumbus.fi>
Date: 1996/08/01
Message-ID: <32011278.65B1_at_pp.kolumbus.fi>#1/1
Date: 1996/08/01
Message-ID: <32011278.65B1_at_pp.kolumbus.fi>#1/1
Erik Johnson wrote:
>
> I need to calculate the number of hour between 2 dates. So if I had:
>
> date_a 7/31/96 10:10:10
> date_b 7/31/96 12:12:12
>
> date_b - date_a = 2 hrs.
>
> How can I do this in a SQL statement with Oracle?? Just subtracting the
> dates gives me nothing.
It gives you the difference in days, decimals too. Think: how many hours is a day? Received on Thu Aug 01 1996 - 00:00:00 CEST