Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Time Operations
> 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