Collections:
FLOOR, CEILING, ROUND - Converting Values to Integers in SQL Server
How To Convert Numeric Values to Integers in SQL Server Transact-SQL?
✍: FYIcenter.com
Sometimes you need to round a numeric value into an integer. SQL Server 2005 offers you a number of ways to do this:
The tutorial exercise below gives some good examples of converting numeric values to integers:
SELECT FLOOR(1234.5678); SELECT CEILING(1234.5678); SELECT ROUND(1234.5678, 0, 0); SELECT CAST(1234.5678 AS INT); SELECT CONVERT(INT, 1234.5678); GO 1234 1235 1235.0000 1234 1234
⇒ ROUND() - Rounding Values to Specific Precisions in SQL Server
⇐ Mathematical Functions Supported by SQL Server 2005 in SQL Server
⇑ Numeric Expressions and Functions in SQL Server Transact-SQL
2017-03-22, 7473🔥, 0💬
Popular Posts:
How Many Groups of Data Types in MySQL? MySQL support 3 groups of data types as listed below: String...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Concatenate Two Binary Strings Together in SQL Server Transact-SQL? SQL Server 2005 allows to...