Discussion: Rounding not working
Afficher un message
Vieux 25/03/2008, 20h00   #1
Faye
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Rounding not working

When I

SELECT CAST(96.58 AS DECIMAL(10 , 0)), it returns 97.

When I

SELECT CAST(575629 / 54 AS DECIMAL(10 , 0)), why it returns 10659? It
should return 10660, right?

What am I missing?

Thanks,

Faye Larson
  Réponse avec citation
 
Page generated in 0,04425 seconds with 9 queries