Re: Time Operations

You need to convert 10 mins in a fraction of a day and add that to the first date.

Hth,
--
Sybrand Bakker, Oracle DBA
Daniel <fiudi @@@ hotmail com> wrote in message news:38721d47_at_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 - 12:16:25 CST