Re: Date arithmetic with oracle
From: Pauli Salmu <pauli.salmu_at_pp.kolumbus.fi>
Date: 1996/08/05
Message-ID: <320651BE.44D_at_pp.kolumbus.fi>#1/1
Date: 1996/08/05
Message-ID: <320651BE.44D_at_pp.kolumbus.fi>#1/1
Richard Clapp Jr wrote:
> I'm not sure if it is that easy. He wants true hours between
> events, by the sound of it. What you guys offered was the hours
> by days between the DATE part of the event, and forgot the hours
> part.
Nope. Datatype date always includes the time portion too. Only if you insert to a table without specifying time, it becomes 00:00. Received on Mon Aug 05 1996 - 00:00:00 CEST