Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Time Operations

Re: Time Operations

From: Antoine BRUNEL <abrunel_at_fr.oracle.com>
Date: Wed, 05 Jan 2000 10:40:39 +0100
Message-ID: <38731195.9A495C44@fr.oracle.com>


> select to_date('03:15:00', 'hh:mi:ss') - to_date('03:00:00', 'hh:mi:ss')
> test
> from dual;

I would try :

select to_char(to_date('03:15:00', 'hh:mi:ss') - to_date('03:00:00', 'hh:mi:ss'),'HH:MI:SS')

test
from dual;


Received on Wed Jan 05 2000 - 03:40:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US