rounding decimal to nearest integer value

• sayedkhalid99

  Ten Centuries

  Points: 1394

  More actions

  June 28, 2015 at 11:02 pm

  #309528

  how to round the nearest value after round of decimal and return integer. thanks.

  declare @data decimal(18,2)

  set @data = 5.55

  -- output

  select '5'

  set @data = 5.58

  -- output

  select '6'

• Eirikur Eiriksson

  SSC Guru

  Points: 182947

  More actions

  June 29, 2015 at 12:46 am

  #1808669

  sayedkhalid99 (6/28/2015)

  ---

  how to round the nearest value after round of decimal and return integer. thanks.

  declare @data decimal(18,2)

  set @data = 5.55

  -- output

  select '5'

  set @data = 5.58

  -- output

  select '6'

  Quick suggestion, use the ROUND function to round the decimal and the CONVERT to return an Integer.

  

  USE tempdb;

  GO

  SET NOCOUNT ON;

  declare @data decimal(18,2) = 5.55;

  SELECT CONVERT(INT,ROUND(@data,0,0),0);

• sgmunson

  SSC Guru

  Points: 110644

  More actions

  June 29, 2015 at 9:06 am

  #1808787

  sayedkhalid99 (6/28/2015)

  ---

  how to round the nearest value after round of decimal and return integer. thanks.

  declare @data decimal(18,2)

  set @data = 5.55

  -- output

  select '5'

  set @data = 5.58

  -- output

  select '6'

  I'm at a loss as to what rule you would use for rounding to get a value of 5 from 5.55, but a value of 6 from 5.58 ...

  The ROUND() function will take both of those values to 6 when rounded to zero decimal places. It would require a

  value of less than 5.5 to get a roundiing down to 5. FYI...

  Steve (aka sgmunson)
  Rent Servers for Income (picks and shovels strategy)

• amurjani

  SSC Eights!

  Points: 872

  More actions

  June 30, 2015 at 1:53 pm

  #1809285

  Try this

  declare @a decimal(10,2), @b-2 decimal(10,2), @c decimal(6,0), @d decimal(6,0)

  select @a = 5.49 , @b-2 = 5.58

  select CAST(@a as decimal(10,0)),CAST(@b as decimal(10,0))