Ads by ProfitSence
Close

ROUNDDOWN() function in SQL

Last Updated on Wednesday 5th Oct 2022

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