Problems obtaining data when converting an int to a decimal field.

Question

Problems obtaining data when converting an int to a decimal field.

Navigation

#1 by (2 votes)

1

I have a table with two fields, nombre and cantidad de productos , I'm generating an additional field to see the amount of products consumed in 10 months so I'm doing a select like this:

select nombre, existencia , cast((cantidad/ 10) as decimal(6,2)) from productos

and also ...

select nombre, existencia , convert(decimal (6,2), (cantidad/ 10)) decimal from productos

The problem is that it gives me the whole data and not with decimals, for example like this:

175 / 10 : 17.0 instead of showing it this way 17.5 , where 175 is cantidad . What is missing me?

sql sql-server

asked by Fernando M. Goycochea 21.06.2018 в 23:15

source

1 answer

help with group by in mysql Variable return with p in javascript

score 2 · Accepted Answer

This happens because the conversion to decimal should be done before of the division.

Currently what is happening is that you have a% int , which you divide by 10, and that results in a entire division (without decimals), and then you convert it to decimal .

SELECT nombre, existencia , cast(cantidad as decimal(6,2))/10
from productos 
;