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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Time difference

Re: Time difference

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 28 Mar 2000 18:56:11 +0200
Message-ID: <954263469.20245.1.pluto.d4ee154e@news.demon.nl>

J Gao <jie.gao_at_tequilasoftware.com> wrote in message news:oS4E4.3518$xz1.101680_at_cac1.rdr.news.psi.ca...
> Hi,
>
> Is there any function in Oracle that can calculate the number of minutes
> between two Date columns? Thanks
>
>
>

just substract them and you will get them as a fraction of a day. The rest is obvious.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Mar 28 2000 - 10:56:11 CST

Original text of this message

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