Q: formatting INTERVAL output?
Posted in 1995
Topics: General Discussion
Hi *, I need some help with an ACE report and Informix 4.00 (yes, I know, it's an old version). I have a table with four columns: cur_no serial my_date date from datetime hour to minute to datetime hour to minute In my report, I order by my_date and cur_no, and print in the output section after group of my_date print column 24, group total of to - from, " h" skip 1 line on last row print column 15, "sum:", column 24, total of to - from, " h" Now, if the "total of to - from" is greater then 99:59, the report prints only asterisks. Is there a way to print intervalls longer than 100 hours? Andreas -- ------------------------------------------------------------------------ Andreas Dunker 2B || ! 2B andreas@hacon.de (W. Shakespeare)