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
Â
⇒Numeric Expressions and Functions in SQL Server Transact-SQL
2017-03-27, 2565👍, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Query Multiple Tables Jointly in MySQL? If you want to query information stored in multiple t...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...