Collections:
CAST() - Converting Numeric Expression Data Types in SQL Server
How To Convert Numeric Expression Data Types using the CAST() 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 CAST(expression AS data_type) function. The tutorial exercise below shows you how to use the CAST() function:
-- FLOAT converted to NUMERIC by CAST() DECLARE @pi FLOAT(24); SET @pi = 3.141592E+00; SELECT CAST(@pi AS NUMERIC(5,2)); GO 3.14 -- FLOAT converted to NUMERIC by CAST() DECLARE @x FLOAT(24); SET @x = 12345.12E+00; SELECT CAST(@x AS NUMERIC(10,5)); GO 12345.12305 -- FLOAT converted to INT by CAST() DECLARE @x FLOAT(24); SET @x = 12345.12E+00; SELECT CAST(@x AS INT); GO 12345
⇒ CONVERT() - Converting Numeric Expression Data Types in SQL Server
⇐ Converting Numeric Data Types by Assignment Operations in SQL Server
⇑ Numeric Expressions and Functions in SQL Server Transact-SQL
2017-03-27, 3136🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...