Repository navigation
不要转成科学计数法 #14968
Unanswered
Leofengxuelin
asked this question in
Q&A
不要转成科学计数法
#14968
Replies: 1 comment
|
这一行会变成科学计数法、其他行不会,通常说明 想看到完整数字,在查询里转换一下类型: -- PostgreSQL
SELECT amount::numeric AS amount FROM ...;
-- MySQL
SELECT CAST(amount AS DECIMAL(30, 0)) AS amount FROM ...;另外,如果这是金额字段,建议把列改成 |
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
All reactions