16 lines
376 B
Plaintext
16 lines
376 B
Plaintext
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;
|