ROUNDDOWN() function in SQL

Last Updated On Friday 19th Nov 2021

sql round down

The SQL FLOOR() function rounded up any positive or negative decimal value down to the next least integer value.

Syntax

	FLOOR(expression)
	
  • expression – An expression which is a numeric value or numeric data type. The bit data type is not allowed.
	SELECT FLOOR(25) AS FloorValue;
	

round down sql

You can use TRUNCATE() for this rounddown.

	select TRUNCATE(2.847, 2) as rounddown
	

or

	SELECT Floor(135.675); //for integer rounding, like 135
	

sql server round down

	select floor(12.77) as rounddown

// 12
	
	SELECT FLOOR((12.77*100)/100)  AS RoundedValue

// 12
	

rounddown

	select TRUNCATE(2.847, 2) as roundValue

// 2.84