How to Convert numeric data type with 1 digit decimal

Jayesh Vaghasiya8y ago

i think u try this way

declare @a numeric(10,1) = 7.7

declare @b numeric(10,2) = 0.00

set @b = REPLACE(convert(varchar(16),@a),'.','.0')

select @b

0

Jose Saiz8y ago

Thanks all much for the reply, I understand that 7.7 is 7.70 but in my case which is calculating seconds 7.7 is 7.07 and this is why I am looking for a SQL conversion.

Thank you all

0

Kapil Singh Kumawat8y ago

Hello Jose, 7.7 means 7.70 only not 7.07. If you have some special requirement then please provide some more information

0

Shubham Sharma8y ago

Hello @Jose you can find your ans here: https://gist.github.com/shubhamsharma12147/1535d2e18329920e17784542ec01ecaf

+1

Shweta Lodha8y ago

7.7 is actually 7.70 and not 7.07. Any specific reason, why you need this conversion?

0