Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: date difference

Re: date difference

From: Uwe Schneider <pi_at_nospam.richard-schneider.de>
Date: Tue, 30 Mar 1999 22:22:10 +0200
Message-ID: <37013272.128E1A5F@nospam.richard-schneider.de>


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   | 

Linux - OS al dente! Received on Tue Mar 30 1999 - 14:22:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US