SQL convert decimal to numeric

608 Views Asked by At

I need to convert my result into numeric form.

This is what I have at the moment:

select convert(float,round(avg(spelers.jaartoe),0)) as "gemiddelde toetredingsjaar"
from spelers
1

There are 1 best solutions below

8
Esteban P. On
select cast(floor(avg(spelers.jaartoe))as float) as "gemiddelde toetredingsjaar" from spelers