Re: date difference

From: bjin <jinbo_at_hpsgns1.sgp.hp.com>
Date: Tue, 30 Mar 1999 19:59:11 +0800
Message-ID: <3700BC8E.1C5E43A5@hpsgns1.sgp.hp.com>

Try:

select (date1 - date2) * 24 from ....

The minus of dates is the number of days between them.

Hth
bjin

Alex Rivlin wrote:

> All,
> How can I get difference in hours between two date columns ? I found
> function month_between, but it is not straightforward how to get hours
> out of month. Is there any other way then coding for all 30, 31 day
> months, leap years, etc?
>
> Thank you in advance.
> Alex
Received on Tue Mar 30 1999 - 05:59:11 CST