Re: Time Operations

From: Daniel <_at_@@>
Date: Tue, 4 Jan 2000 17:20:03 +0100
Message-ID: <38721d47@news.datacomm.ch>

Thanks guys for your help. But timediff is only one problem... What's about the following one?

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

                                       *

ERROR at line 1:
ORA-00975: date + date not allowed

Greetings
Dan

Daniel <fiudi_at_hotmail.com> news:3871e86f_at_news.datacomm.ch Received on Tue Jan 04 2000 - 10:20:03 CST