Re: time stamp duration in minutes and seconds

"toto" <parag9i_at_gmail.com> wrote in message news:1152195945.794299.157420_at_s26g2000cwa.googlegroups.com...
> Hi,
>
> Thanks for your suggestion. I have already looked into interval day to
> second ..etc but not successful. Pl help me.
>
> thanks & regards
> pjp
>
> sybrandb wrote:
>
> > 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
>

Well, you may want a simpler method, but the methods available are the methods available. Wishing it were different isn't going to change the facts.
Jim Received on Thu Jul 06 2006 - 10:12:21 CDT