Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: date difference
Hi,
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?
>
there are conversion functions (TO_CHAR) of ORA date datatypes to Julian day numbers and Seconds within a day. Use them!
Uwe
--
Uwe Schneider | Telefon +49 7251 / 82587 Karlsdorfer Str. 31 | Mail pi_at_richard-schneider.de DE-76646 Bruchsal |