Does anyone know how I can format numbers in a select? Eg.
SELECT a.a,
a.b,
(a.a / a.b) c
FROM a;
How can I get c in a specific floating-point format, eg. %3.2f?
In Oracle I think you'd use TO_CHAR for this, but I can't figure it out for MySQL.
Thanks
