blocks|key|367799|text|您可以将结果转换为numeric(x,2)。x+<=+38在哪里。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|367800|select
++++round(630/60.0,2),
++++cast(round(630/60.0,2)+as+numeric(36,2))|code-block|syntax|javascript|367801|返回|367802|10.500000++++10.50|367803|entityMap^0|9|C|M|7|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|W|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|P|$]]

You could cast your result as <code>numeric(x,2)</code>. Where <code>x &lt;= 38</code>.
<pre><code>select
 round(630/60.0,2),
 cast(round(630/60.0,2) as numeric(36,2))
</code></pre>
Returns
<pre><code>10.500000 10.50
</code></pre>

blocks|key|583730|text|您可以使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|583731|select+cast((630/60.0)+as+decimal(16,2))|code-block|syntax|javascript|583732|在SQL+Server中|583733|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You can use:
<pre><code>select cast((630/60.0) as decimal(16,2))
</code></pre>
in SQL Server

blocks|key|583784|text|Declare+@number+float+=+35.44987665;
Select+round(@number,2)+|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|583785|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>Declare @number float = 35.44987665;
Select round(@number,2) 
</code></pre>

blocks|key|583943|text|CAST(QuantityLevel+AS+NUMERIC(18,2))|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|583944|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>CAST(QuantityLevel AS NUMERIC(18,2))
</code></pre>

blocks|key|583798|text|DECLARE+@porcentaje+FLOAT

SET+@porcentaje+=+(CONVERT(DECIMAL,ABS(8700))+*+100)+/+CONVERT(DECIMAL,ABS(37020))

SELECT+@porcentaje|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|583799|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>DECLARE @porcentaje FLOAT

SET @porcentaje = (CONVERT(DECIMAL,ABS(8700)) * 100) / CONVERT(DECIMAL,ABS(37020))

SELECT @porcentaje
</code></pre>

blocks|key|583866|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|583867|++++SELECT+CAST(ROUND([Amount+1]/60,2)+AS+DECIMAL(10,2))+as+TOTAL|code-block|syntax|javascript|583868|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this:

<pre class="lang-sql prettyprint-override"><code> SELECT CAST(ROUND([Amount 1]/60,2) AS DECIMAL(10,2)) as TOTAL
</code></pre>

blocks|key|367923|text|这在PostgreSQL和甲骨文中都有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|367924|SELECT+ename,+sal,+round(((sal+*+.15+%2B+comm)+/12),2)
FROM+emp+where+job+=+'SALESMAN'|code-block|syntax|javascript|367925|entityMap|0|LINK|mutability|MUTABLE|url|https://en.wikipedia.org/wiki/PostgreSQL^0|2|A|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

This works in both with <a href="https://en.wikipedia.org/wiki/PostgreSQL" rel="nofollow noreferrer">PostgreSQL</a> and Oracle:
<pre><code>SELECT ename, sal, round(((sal * .15 + comm) /12),2)
FROM emp where job = 'SALESMAN'
</code></pre>

blocks|key|583768|text|下面的查询很有用，也很简单-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|583769|declare+@floatExchRate+float;
set+@floatExchRate=(select+convert(decimal(10,+2),+0.2548712))
select++@floatExchRate|code-block|syntax|javascript|583770|输出为0.25。|583771|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Following query is useful and simple-
<pre><code>declare @floatExchRate float;
set @floatExchRate=(select convert(decimal(10, 2), 0.2548712))
select @floatExchRate
</code></pre>
Gives output as 0.25.

blocks|key|368053|text|无论你在面额中使用什么，都应该是十进制的。例如，1548/100将提供15.00。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|368054|如果在我们的示例中用100.0替换100，那么我们将得到15.48|368055|select+1548/100
15.00000

select+1548/100.0
15.4800

0|code-block|syntax|javascript|368056|entityMap^0|O|8|Z|5|0|A|5|H|3|S|5|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|T|8|@$9|U|A|V|B|C]|$9|W|A|X|B|C]|$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|10|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|N|$]]

Whatever you use in denomination should be in decimal. For example, <code>1548/100</code> will give <code>15.00</code>.
If we replace <code>100</code> with <code>100.0</code> in our example then we will get <code>15.48</code>
<pre><code>select 1548/100
15.00000

select 1548/100.0
15.4800

0
</code></pre>

blocks|key|583927|text|作为对以下答案的补充，在公式中使用INT或非decimal数据类型时，请记住将值乘以1和您喜欢的小数位数。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|583928|也就是说，-+TotalPackages是一个INT，分母TotalContainers也是，但我希望我的结果最多有六位小数。|offset|length|style|CODE|583929|因此：|583930|((m.TotalPackages+*+1.000000)+/+m.TotalContainers)+AS+Packages,|code-block|syntax|javascript|583931|entityMap^0|0|7|D|N|3|T|F|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@$D|S|E|T|F|G]|$D|U|E|V|F|G]|$D|W|E|X|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|Z|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|P|$]]

As an add-on to the answers below, when using INT or non-decimal datatypes in your formulas, remember to multiply the value by 1 and the number of decimals you prefer.
I.e. - <code>TotalPackages</code> is an <code>INT</code>, and so is the denominator <code>TotalContainers</code>, but I want my result to have up to six decimal places.
Thus:
<pre><code>((m.TotalPackages * 1.000000) / m.TotalContainers) AS Packages,
</code></pre>

blocks|key|583677|text|以下代码片段可能会对您有所帮助：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|583678|select+SUBSTR(ENDDTTM,1,+9),+extract(DAY+FROM+(ENDDTTM)),+ENDDTTM,+BEGINDTTM,++(ENDDTTM+-+BEGINDTTM),substr(BEGINDTTM,+1,15),+substr((ENDDTTM+-+BEGINDTTM),+12,+8),
round((substr((ENDDTTM+-+BEGINDTTM),+12,+2)*+3600+%2B+substr((ENDDTTM+-+BEGINDTTM),+15,+2)*60+%2B++substr((ENDDTTM+-+BEGINDTTM),+18,+2)),2)+as+seconds,
round((substr((ENDDTTM+-+BEGINDTTM),+12,+2)*+60+%2B+substr((ENDDTTM+-+BEGINDTTM),+15,+2)+%2B++substr((ENDDTTM+-+BEGINDTTM),+18,+2)/60+),+2)as+minutes,
round((substr((ENDDTTM+-+BEGINDTTM),+12,+2)+%2B+substr((ENDDTTM+-+BEGINDTTM),+15,+2)/60+%2B++substr((ENDDTTM+-+BEGINDTTM),+18,+2)/3600+),2)++as+hours|code-block|syntax|javascript|583679|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The following snippet might help you:

<pre><code>select SUBSTR(ENDDTTM,1, 9), extract(DAY FROM (ENDDTTM)), ENDDTTM, BEGINDTTM, (ENDDTTM - BEGINDTTM),substr(BEGINDTTM, 1,15), substr((ENDDTTM - BEGINDTTM), 12, 8),
round((substr((ENDDTTM - BEGINDTTM), 12, 2)* 3600 + substr((ENDDTTM - BEGINDTTM), 15, 2)*60 + substr((ENDDTTM - BEGINDTTM), 18, 2)),2) as seconds,
round((substr((ENDDTTM - BEGINDTTM), 12, 2)* 60 + substr((ENDDTTM - BEGINDTTM), 15, 2) + substr((ENDDTTM - BEGINDTTM), 18, 2)/60 ), 2)as minutes,
round((substr((ENDDTTM - BEGINDTTM), 12, 2) + substr((ENDDTTM - BEGINDTTM), 15, 2)/60 + substr((ENDDTTM - BEGINDTTM), 18, 2)/3600 ),2) as hours
</code></pre>

blocks|key|368083|text|我发现STR函数是完成这一任务的最简洁的方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|368084|SELECT+STR(ceiling(123.415432875),+6,+2)|code-block|syntax|javascript|368085|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I find the STR function the cleanest means of accomplishing this. 

<pre><code>SELECT STR(ceiling(123.415432875), 6, 2)
</code></pre>

I need to convert minutes to hours, rounded off to two decimal places. I also need to display only up to two numbers after the decimal point. So if I have minutes as 650, then hours should be 10.83.
Here's what I have so far:
<pre><code>Select round(Minutes/60.0,2) from ....
</code></pre>
But in this case, if my minutes is, say, 630 - hours is 10.5000000. But I want it as 10.50 only (after rounding). How do I achieve this?

Rounding off to two decimal places in SQL

SQL Server

我需要将分钟转换为小时，四舍五入到小数点后两位。我还需要在小数点后最多显示两个数字。所以如果我的分钟数是650，那么小时数应该是10.83。这是我到目前为止所知道的：Select round(Minutes/60.0,2) from ....但在这种情况下，如果我的分钟是，比如说，630 -小时是10.5000000。但我只想要10.50 (四舍五入后)。我该如何实现这一点？

问在SQL中舍入到小数点后两位
EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在SQL中舍入到小数点后两位EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在SQL中舍入到小数点后两位
EN