Rounding a number to 2 decimal places in SQL SERVER

0

Use T-SQL Convert Function.


Select convert ( decimal(8,2) , 9.4125 )

Output: 9.41

Get Free Email Updates!

Signup now and receive free offers, discounts & coupon codes

I agree to have my personal information transfered to Mad Mimi ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge

This site uses Akismet to reduce spam. Learn how your comment data is processed.