Returning formatted output
Posted in 1997
Tauren Mills — — source: Informix-list mailing list archive (1991-1998)
Is there a way to return an expression as a Money type with set decimal point precision? For instance, in the following select, items.sale_price is MONEY(6,2) and sales.discount is INTEGER. The equation sometimes returns results that have more than 2 decimal places. SELECT items.sale_price - ((items.sale_price * sales.discount) / 100), items.name, sales.name, sales.discount, items.sale_price FROM sales, items WHERE sales.sale_id = items.sale_id; I am using Informix Online Workgroup Server 7.12 on Sun Solaris 2.5.1 Thanks, Tauren tauren@groovee.com