Re: Time Operations

From: Daniel <_at_@@>
Date: Wed, 5 Jan 2000 13:18:51 +0100
Message-ID: <387336ca@news.datacomm.ch>

Yeah looks good, but Oracle doesn't like it at all... Have you tried it?

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;

                *

ERROR at line 1:
ORA-01481: invalid number format model

Greetings
Dan

Antoine BRUNEL <abrunel_at_fr.oracle.com> wrote in message news:38731195.9A495C44_at_fr.oracle.com...

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 - 06:18:51 CST