>I'm creating a report using report writer and have a need to convert
>hours fields which are in decimal format such as 10.25 and 0.50 to 
>hours.minutes format such as 10.15 and 0.30.  I have tried many 
>different ways to accomplish this but have yet to find one that works.

In the SELECT statement of your .QUERY section, you could use an expression
like:
      select int4(x) - 0.6*(x - int4(x))
where x is your input value.  This appears to work for both positive and 
negative x.
                   Charles

Ingres Q & A

To William's Home Page

© William Yuan 2000

Email William