Time Operations

From: Daniel <_at_@@>
Date: Tue, 4 Jan 2000 13:34:39 +0100
Message-ID: <3871e86f@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 - 06:34:39 CST