Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date conversion problem
NO, The result is in DAYS!!!!!!!!
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail address "Kjell Nannestad" <knannest_at_c2i.net> wrote in message news:hoRH8.3690$qE4.391939_at_juliett.dax.net...Received on Sat May 25 2002 - 15:30:53 CDT
> The result is in seconds, so you can easily make a function returing what
> you want.
>
>
>
> "Bob laFouine" <Boblafouine_at_hotmail.com> wrote in message
> news:%BQH8.17997$Vd1.1031502_at_weber.videotron.net...
> > I'm comparing 2 dates and I need the result in HH24:MI:SS but I get
the
> > result as a number
> >
> > here is my simple query
> >
> > select fin_update - debut_update
> > from lcni_mgr.update_table
> >
> > I'm looking for the magic formula
> >
> > Thank you
> >
> > P. Courtois
> > courtoip_at_videotron.com
> >
> >
>
>