SELECT FORMAT(1.234,0,'en_US'); SELECT FORMAT(1.234,1,'en_US'); SELECT FORMAT(1.234,2,'en_US'); SELECT FORMAT(1.234,3,'en_US'); SELECT FORMAT(1.234,4,'en_US'); SELECT FORMAT(1.234e-2,4,'en_US'); SELECT FORMAT(-1.234,4,'en_US'); WITH RECURSIVE cte(n) AS ( SELECT 1 n UNION ALL SELECT 100+n FROM cte WHERE n<1000 ) SELECT FORMAT(n+0.01,3,'foo_bar') FROM cte; SHOW WARNINGS;