حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Rounding up to nearest 0.5 in SQL Server

akhter

I want to round 3.8 to 3.5 in sql.

please guide

thanks

dharmend...

0 1

Refer below query.

SELECT CAST((FLOOR(3.8*2.0)/2.0) AS NUMERIC(18,1)) AS Number

Output

3.5

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html