Re: Date Arithmetic

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 14 Jul 2006 12:52:30 -0700
Message-ID: <bf46380607141252g1e5eeec6x88dd3458bbdd96f2@mail.gmail.com>

On 7/14/06, Nirmalya Das <nirmalya_at_hln.com> wrote:
>
> Hi All,
>
> I am trying to find the "number of minutes" between "sysdate" and
> "flush_stamp".
>
>
>

an example:

select (later_215 - sysdate) * 1440
from (

select

the time 215 minutes from now sysdate+(215*(1/1440)) later_215 from dual )

see http://www.dbazine.com/oracle/or-articles/still2

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 14 2006 - 14:52:30 CDT