SELECT CAST（'0.042'AS decimal）* 1000 [英] SELECT CAST('0.042' AS decimal)*1000

问题描述

SELECT CAST('0.042' AS decimal)*1000

将值返回0，但我想显示42，我该怎么做



问候

Azeem

returns value as 0, but i want to display 42, how can i do that

regards
Azeem

推荐答案

尝试

SELECT FLOOR(CAST('0.042' AS NUMERIC(10,3)) * 1000)

我怀疑 CAST 以十进制而不指定精度和比例结果的比例为零，这意味着没有小数位。



这些所有收益率都为42 t。

I suspect that CASTing as Decimal without specifying Precision and Scale results in a Scale of zero which means no decimal places.

These all yield 42 as the result.

SELECT CAST('0.042' AS decimal(18,3))*1000

SELECT CAST(0.042 AS decimal(18,3))*1000

SELECT CAST('0.042' AS numeric(18,3))*1000

SELECT CAST(0.042 AS numeric(18,3))*1000

SELECT CAST('0.042' AS real)*1000

SELECT CAST(0.042 AS real)*1000

SELECT CAST('0.042' AS float(24))*1000

SELECT CAST(0.042 AS float(24))*1000

试试这个,,,,,

Try this,,,,,

SELECT FLOOR(CAST('0.042' AS NUMERIC(10,3)) * 1000)

问候，

Nirav Prabtani .. :)

Regards,
Nirav Prabtani..:)

这篇关于SELECT CAST（'0.042'AS decimal）* 1000的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！