SQL columns

Many thanks to all those that replied to my last question!

I now have a problem where I have a .sql script I need to execute to give me a report. In it I have a column defined to be of type A05. I do a select on col1 - col2 where col1 and col2 are defined to be of type date. I convert it to HH24:MI format. So far, everything is great. However, I'd like to see a summation totalling up col1 - col2 at the bottom of my 'report' for all the rows. Nothing happens for the summation, and I believe it's because I've got the column defined to be A05 (though I need it for displaying my rows). The code looks something like:

column col_name A05

break on report
compute sum of col_name

select to_char(to_date(trunc(3600 * 24 * (col1 - col2)),'SSSSS'), 'HH24:MI') col_name from my_table;

Any thoughts?

laura Received on Fri Aug 19 1994 - 22:10:29 CEST