Two digits to the right of the decimal point

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jan Löfgren SSC Enthusiast Points: 197 More actions · Answer 1

Hi,

did you try already this ?

CAST(expression AS DECIMAL (10,2))

10 = Number of digits in a number

2 = Number of digits right after the decimal point

Regards,

Jan

Julian Kuiters SSCertifiable Points: 6585 More actions · Answer 2

Money Datatype always has four digits to the right of the decimal place.

Jan's example above of using DECIMAL (x,2) will reduce the number of decimal places.

zdenek douda SSC-Addicted Points: 419 More actions · Answer 3

And why

In the following table, the column on the left represents the style value for money or smallmoney conversion to character data.

Value	Output
0 (default)	No commas every three digits to the left of the decimal point, and two digits to the right of the decimal point; for example, 4235.98.
1	Commas every three digits to the left of the decimal point, and two digits to the right of the decimal point; for example, 3,510.92.
2	No commas every three digits to the left of the decimal point, and four digits to the right of the decimal point; for example, 4235.9819.

thanks

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 4

That is correct. Conversion from money to charachter... However, in your example, you're converting to money, not char.

I guess what you want is like this...

declare @m money

set @m = 172670.8839

select convert(varchar(12), @m, 0)

------------

172670.88

/Kenneth

zdenek douda SSC-Addicted Points: 419 More actions · Answer 5

SSC-Addicted

Points: 419

September 7, 2004 at 7:41 am

Yes,

thank you, that is what I need.

zdenek