DATE ARITHMETIC QUESTION

From: <wagen123_at_yahoo.com>
Date: 28 Jan 2005 13:22:36 -0800
Message-ID: <1106947356.439046.281840@f14g2000cwb.googlegroups.com>

The following query shows the DURATION in seconds. SQL> select
NEXT_TIME,COMPLETION_TIME,(COMPLETION_TIME-NEXT_TIME)*60*60*24 DURATION from v$archived_log where sequence# = 18220;

NEXT_TIME COMPLETION_TIME DURATION
------------------ ------------------ ----------
28-JAN-05 12:28:32 28-JAN-05 12:28:51 19 Is there a way to display the DURATION in the following format (HH24:MI:SS) easily ?

NEXT_TIME COMPLETION_TIME DURATION
------------------ ------------------ ----------
28-JAN-05 12:28:32 28-JAN-05 12:28:51 00:00:19 Thanks
wagen Received on Fri Jan 28 2005 - 15:22:36 CST