Does SQL Server support rounding or truncation?

Question

Let's say I insert a 64bit double floating point in the DECIMAL (17.5) field. Does the value contain rounding or truncation?

+2

math floating-point sql-server

Esteban araya 21 Aug 09 at 20:20

source to share

1 answer

Eric · Accepted Answer · 2009-08-21T20:36:37+0000

These are the rounds:

select cast(9.12345 as decimal(10,4))

Returns 9.1235