Appearance
数据类型
数字。
SELECT 123456789123456789123456789123456789 AS result;| result |
|---|
| 123456789123456789123456789123456789 |
1 row in setSELECT CAST(8.123456789123456789 AS REAL) AS result;| result |
|---|
| 8.123456789123457 |
1 row in setSELECT CAST(8.123456789123456789 AS FLOAT) AS result;| result |
|---|
| 8.12346 |
1 row in set