Re: Time Operations

multiply by 24 will give the results in hours

             by 24*60 in minutes
      and  by 24*60*60 in seconds

Hth,

--
Sybrand Bakker, Oracle DBA
Daniel <fiudi @@@ hotmail com> wrote in message news:3871e86f_at_news.datacomm.ch...
> Hello
>
> I'm trying to do some time calculations like:
>
> select to_date('03:15:00', 'hh:mi:ss') - to_date('03:00:00', 'hh:mi:ss')
> test
> from dual;
>
> TEST
> ---------
> .01041667
>
> The problem is to set 'TEST' back to a time (resp. date) format.
> Any suggestions?
>
> Thanks
> Dan
>
>
>
>
Received on Tue Jan 04 2000 - 07:20:25 CST