FORMAT (MySQL)
Naar navigatie springen
Naar zoeken springen
Quite handy at times:
- Figures are rounded off as how I expect
- Be aware that the output is a string, not a number:
select 4.400000, format(4.400000, 2), 4.5, format(4.5, 2), 4.499, format(4.499, 2), 4.4499, format(4.4499, 2)
Output:
4.400000 4.40 4.5 4.50 4.499 4.50 4.4499 4.45