format result with no decimals

[hothousegraphix]

IF I'm doing a simple query like

SELECT product_price - product_saleprice AS savings FROM exp_foxee_skus WHERE id='{entry_id}'

which yields a value of say 8.00. How can I eliminate the ".00" and just show round numbers?

Thanks

[guelphdad]

use ROUND

[Dan Grossman]

In general, formatting output is the job of the application UI, not the database system.