Query to return one digit after decimal place in SQL Server

chetan

SOLVED CLOSED ACTIVE ANSWERED
User: chetan
Posted: on Aug 07, 2019 04:38 AM
Forum: SQL Server
Answer: 1
Views: 1396

User Interface: Electricity use: 3400.00(value coming from db by the below query)

I wanted to put validation for the below query such that it should be 3400.0 :

SELECT @RESULT =ENQ.ELECTRICITY_USE FROM REG_REGISTRATION_MST_T REG JOIN ENQ_ENQUIRY_MST_T ENQ ON REG.ENQ_ID=ENQ.ENQUIRY_ID WHERE REG.REGISTRATION_ID=

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Aug 07, 2019 04:43 AM
Modified: on Aug 07, 2019 04:47 AM
Report

Hi chetan,

Use Cast function for rounding to 1 decimal place in SQL Server.

Query

DECLARE @Electricity VARCHAR(10)
SET @Electricity = '3400.84' 
SELECT CAST(@Electricity AS DECIMAL(18,1)) AS Electricity

Output

Electricity
3400.0

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

Query to return one digit after decimal place in SQL Server

Company

Explore

Follow us

Contact Us