Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: time stamp duration in minutes and seconds
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
> >