Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date conversion problem
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
>
>
Received on Sat May 25 2002 - 14:14:21 CDT