In this article, I will explain how to Convert Decimal Numbers to Money with cents / without cents in SQL.
You might also like to read How to convert Gregorian date to Hijri date SQL Server 2012
Convert Decimal to Money SQL
I have a decimal number like 71567536.100000, I need to convert it to money format
- with cents to be like this 71,567,536.10 ر.س
- without cents to be like this 71,567,536 ر.س
Convert Decimal to Money with Cents in SQL
You can use one of the below quires
SELECT STUFF( convert(varchar, convert(money,71567536.100000),1) , 1, 0,'.') + N' ر.س ' as 'Budget'
SELECT convert(varchar(100), cast(71567536.100000 as money), 1)+ N' ر.س ' as 'Budget'
Output
![Convert Decimal to Money SQL Convert Decimal To Money With Cents In SQL Server](https://i0.wp.com/spgeeks.devoworx.com/wp-content/uploads/2014/10/convertwithcents.png?resize=827%2C239&ssl=1)
Convert Decimal To Money Without Cents In SQL Server
You can use one of the below quires
SELECT parsename( convert(varchar(100), cast(71567536.100000 as money), 1),2) + N' ر.س ' as 'Budget'
SELECT replace( convert(varchar, cast(floor(71567536.100000) as money),1), '.00', '') + N' ر.س ' as 'Budget'
Note: The second statement faster than the first with 21 NS.
Output
![Convert Decimal to Money SQL Convert Decimal To Money Without Cents In SQL Server](https://i0.wp.com/spgeeks.devoworx.com/wp-content/uploads/2014/10/convertwithoutcents.png?resize=941%2C228&ssl=1)
Conclusion
In conclusion, we have learned how to Convert Decimal to Money SQL Server.
Applies To
- SQL Server 2016
- SQL Server 2012