Re: getting time difference in hours between two date columns

"Matthias Wirtz" <Matthias.Wirtz_at_epost.de> wrote in message news:b8p87m$c1ps6$1_at_ID-151394.news.dfncis.de...
> Hi,
>
> I want to get the time difference in minutes of two date columns. I tried
it
> with:
>
> SELECT ROUND((from_date - until_date)*24*60) FROM date_table;
>
> It seems to work. Is there a special function like BETWEEN_DAYS for this
> purpose too?
> --
> Matthias Wirtz - Norfolk, USA
>
>

No there isn't. The function you mention has been developed to deal with leap years. A day always consists of 24 hours and 60 minutes in an hour, so there is no need for the function.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address