Re: time stamp duration in minutes and seconds

toto wrote:
> Hi,
>
> Because according me more simple method should be available in Orale to
> arrive duration in minutes and seconds other than "extract" method.
>
> thanks & regards
> pjp
>
>
> robertsboyle_at_gmail.com wrote:
>
> > what exactly is wrong with extract? That is what it is there for.
> >
> >
> > toto wrote:
> > > Hi,
> > >
> > > I have following questions,
> > >
> > > 1. I want to know difference between two timestamps in minutes and
> > > seconds ? Is
> > > there any other way than "extract " method.
> > >
> > > 2. How it is going take part of fraction of seconds while arriving
> > > exact
> > > difference
> > >
> > > for e.g.
> > >
> > > 18:21:32 SQL> select localtimestamp - (localtimestamp + 10 ) from dual;
> > >
> > > LOCALTIMESTAMP-(LOCALTIMESTAMP+10)
> > > -----------------------------------------------------------------------
> > > -000000009 23:59:59.922523
> > >
> > > I want this difference in minutes and seconds only. ( Preferably other
> > > than
> > > "extract", I am sure there must me some simple way to arrive at this
> > > solution )
> > >
> > > thanks & regards
> > > pjp

Look for the INTERVAL functions in the SQL reference manual.

-- 
Sybrand Bakker
Senior Oracle DBA