Date difference update question

From: Andy <andy.konopka_at_camtronics.com>
Date: Tue, 1 May 2001 09:23:27 -0500
Message-ID: <NEzH6.1400$A07.341872@homer.alpha.net>

Hello,

Here is my problem, I am getting the results that I want but I cannot format the output so someone could read it -- any ideas please post them:

SQL statement
SELECT WO_NO, TO_CHAR(REAL_F_DATE,'DDHH24MI') - TO_CHAR(REAL_S_DATE,'DDHH24MI') AS DIFFERENCE FROM ACTIVE_SEPARATE; Output

WO_NO DIFFERENCE
---------- ----------

         2        100   -- THIS IS 1 HOUR
        3      31550  -- THIS HAS 3 DAYS 15 HOURS 50 MINUTES
        13        100  -- THIS IS AGAIN 1 HOUR

Appreciate any help or advice Received on Tue May 01 2001 - 09:23:27 CDT