如何显示此值 [英] how to show this value
问题描述
我今天遇到的特殊团队
我真的很需要你
以前，当我向客户显示金额时，它显示为
234.340000
在客户提出新要求后，我只需将0替换为''''
像这样显示
234.34
鞠躬，我有问题，
我的客户输入金额
234.034000
现在我只想展示
234.034
或者如果我的克林特进入
234.0023000
那我想展示
234.0023
请帮我解决...
Respected team i have a problem today
and i realy need of u
previously when i was displaying amount to my client it was displaying like
234.340000
after the client new requirment i simply replace 0 with ''''
and it display like this
234.34
bow i have a problem,
my client enter amount
234.034000
now i just want to show
234.034
or if my clint enter
234.0023000
then i want to show
234.0023
plz guaid me how can i solve it...
推荐答案
使用CAST函数:
Use the CAST function:
SELECT CAST(123.045006 AS numeric(8,2))
将为您提供两位小数:123.05
Will give you a two decimal place number: 123.05
SELECT CAST(234.0023000 AS numeric(8,4))
会给您234.0023
Will give you 234.0023
这篇关于如何显示此值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
