Collections:
CONVERT() - Converting Numeric Expression Data Types in SQL Server
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL?
✍: FYIcenter.com
If you want to convert the data type of a numeric expression to a new data type, you can use the CONVERT(data_type, expression) function. The tutorial exercise below shows you how to use the CONVERT() function:
-- FLOAT converted to NUMERIC by CONVERT() DECLARE @pi FLOAT(24); SET @pi = 3.141592E+00; SELECT CONVERT(NUMERIC(5,2), @pi); GO 3.14 -- FLOAT converted to NUMERIC by CONVERT() DECLARE @x FLOAT(24); SET @x = 12345.12E+00; SELECT CONVERT(NUMERIC(10,5), @x); GO 12345.12012 -- FLOAT converted to INT by CONVERT() DECLARE @x FLOAT(24); SET @x = 12345.12E+00; SELECT CONVERT(INT, @x); GO 12345
⇒ CONVERT() - Converting Character Strings to Numeric Values in SQL Server
⇐ CAST() - Converting Numeric Expression Data Types in SQL Server
⇑ Numeric Expressions and Functions in SQL Server Transact-SQL
2017-03-27, 3118🔥, 0💬
Popular Posts:
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...