Re: Q: formatting INTERVAL output?

In article <26PMQK$03m@hacon.de>, andreas@hacon.de (Andreas Dunker) says: > >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) Hi Andreas, define a varibale with INTERVAL-Type such like: tot INTERVAL(3). Then you can save values up to 999 hours, INTERVAL(4) 9999 hours, ..... Gruss, Stefan --- Stefan Gutsche, sg@ivu-berlin.de, +49 30 85906-341 IVU GmbH, Bundesallee 88, D-12161 Berlin, fax -111